Great! That worked well for my Access problem, thank-you. However, within the same script, I need to open an excel file, run an excel macro, and save/close the xls. Using both methods you presented above, this is not working for me. For instance, if I use the line: Run>"C:\Program Files\Microsoft Of...

I have a basic script that opens an Access database and clicks some buttons on a form to run macros and I want to enhance the script so that if the database form design changes my script will still work. Basically, I need to send the DoCmd.RunMacro command and I'm not sure how to do that. I wrapped ...