Prompt user for file name and location through browser such as "File Open/Save" and import file as ""
I have a multi user Access 2000 application. The buyers send out an excel spreadsheet "Open Purchase Order Report" from access. The suppliers will update "Vendor Promise Date" and "Vendor Notes". The supplier will return the excel spreadsheet via e-mail.
The process currently - 1 person opens the e-mail from the supplier and saves the excel spreadsheet as
"Linda.xls" to her desktop. The person then runs a macro within the database which is directed to the desktop and then to "Linda.xls". The macro will import the file and run updates from the spreadsheet - this allows the next
report going out to the suppliers to include the notes and dates they have provided.
I would like to allow the buyers to open the e-mail and save the attachment as whatever name they desire. Then
when they run the macro I need the database to:
Prompt for file name and location - through a browser - "Files Open/Save" - this is a must.
Then transfer spreadsheet into access as "Linda" - this should be set in code and not an option.