Question about macros
Posted by David on November 18, 2001 8:44 AM
I would like to know if the following is possible to do with an Excel macro:
1: Data will be sent to Excel from Access, macro needs to run after data has been sent.
2: Print a specific worksheet page on a network printer (I know I can do this one)
3: Open an Access database and enter a login and password.
3a: copy and paste information from worksheet to DB form.
3b: Close DB.
4: Close and Save worksheet as todays' date.
Thank in advance for any and all advise.