Tech Support Guy banner

How to fire an Excel macro from MSAccess?

1685 Views 1 Reply 1 Participant Last post by  stevezal
I have an Excel spreadsheet that is always open. I want to use Visual Basic in MSAccess to execute an Excel macro based upon certain conditions in the MSAccess database. I can use Auto Open to run the macro from a closed Excel Spreadsheet from MSAccess by closing it and then opening the spreadsheet, but I can't find out how to fire the macro from MSAccess when the spreadsheet is already open. Appreciate any insights. Thanks.

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit, Build 18362, Installed 20190915061435.000000-420
Processor: Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz, Intel64 Family 6 Model 142 Stepping 9, CPU Count: 4
Total Physical RAM: 8 GB
Graphics Card: Intel(R) HD Graphics 620, 1024 MB
Hard Drives: C: 237 GB (27 GB Free);
Motherboard: ASUSTeK COMPUTER INC. UX430UA, ver 1.0, s/n N0CV1735MB0032184
System: American Megatrends Inc., ver _ASUS_ - 1072009, s/n H9N0CV01N072361
Antivirus: Windows Defender, Disabled
Not open for further replies.
1 - 2 of 2 Posts
As I said in my post, this Excel spreadsheet is always open. I merely need to run one of its macros based upon a condition in MSAccess.
1 - 2 of 2 Posts
Not open for further replies.