Link to home
Create AccountLog in
Avatar of ctownsen80
ctownsen80Flag for Afghanistan

asked on

Run Excel Macro while Closed

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

Thanks!
Avatar of Nasir Razzaq
Nasir Razzaq
Flag of United Kingdom of Great Britain and Northern Ireland image

I would say No.
ASKER CERTIFIED SOLUTION
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of ctownsen80

ASKER

@MartinLiss -- you mean export data to the sheet via access, instead of trying to import data into the workbook? Or something else?
All I'm saying is that you can get data from a closed workbook and here's an example.
Is VB.NET involved in this? as its one of the zones. If it is, you can export to Excel using OLEDB driver.