>I have a little project. The user will use a VFP interface to select procurement items from a list. The VFP app will then package the items with formulas in an Excel sheet and email them to Vendors. The vendors will enter unit prices and return (send back) the completed Excel spread sheet to the [procurement] user's mailbox.
>
>The problem is that my design creates one spreadsheet (one file name). When they are returned, they will all have the same name. This may conflict (overwrite) previously received documents of the same name. AT the very least, it would confuse my user.
>
>My options are to create a seperate (but same) spreadsheet for each vendor with automation, or rename the "master" sheet file prior to each mailing.
>
>Those options seem excessive. Is there a way I can rename an attachment on the fly? Is there a cleaner way to do this than my recognized options.
>
>Thanks

One thought was to include a macro that would rename the master (recieved) and save it once the vendor recieves it, and then delete the "master". I don't like mailing documents with macros!