Running Other Office Applications w/ Excel Visual Basic
-
Is there a way to open a specific Access file using Excel Visual Basic. I have a PC that runs tasks 24/7/365 which moves files, creates new files using Microsoft Querry, send email reminders, but I cannot figure out how to open a specific Access file that contains an autoexec macro to handle all of the querry and reporting functions. Any help would be greatly appreciated.
-
Is there a way to open a specific Access file using Excel Visual Basic. I have a PC that runs tasks 24/7/365 which moves files, creates new files using Microsoft Querry, send email reminders, but I cannot figure out how to open a specific Access file that contains an autoexec macro to handle all of the querry and reporting functions. Any help would be greatly appreciated.
Found this link on MS Support, running a Access Macro from Excel, it uses DDE (Dynamic Data Exchange): http://support.microsoft.com/default.aspx?scid=kb;en-us;131921