Run Excel Macro while Closed
Posted on 2013-05-16
I have an excel file (.xlsm) located at "C:\My Documents". Within this file, there is a macro called "RefreshData" that goes out to a server and pulls in data. Not sure if its relevant, but the server is called "Server123" and the table is pulls in is called "TableData5". I would like to know is it possible to run this macro without actually opening the file. I would like to be able to click a button in MC Access...lets called the database "AccessDB.accdb" and its also located in "C:\My Documents"... , and excecute the process to make this happen.
Is this possible? If it is, can you please create a VB script to insert into an MS Access module to run?
Also, please don't send me a link to a similar question :) Appreciated, but sort of in a time crunch to figure this out. Direct input is much appreciated :D