trigger excel macro with VBA

  • Thread starter Thread starter Timmy
  • Start date Start date
T

Timmy

I need to trigger excel macro with VBA. It used to work on another computer,
but when I try to run it my PC the Access VBA does not see my Personal.xls
(macro file)
 
Hi Timmy,

Did you check your macro security settings in Excel on the new machine?
If that does not help, post more information such as versions of Access and
Excel and the code that used to work, both in Access and Excel.

Clifford Bass
 
Clifford Bass said:
Hi Timmy,

Did you check your macro security settings in Excel on the new
machine?
If that does not help, post more information such as versions of Access
and
Excel and the code that used to work, both in Access and Excel.

Clifford Bass
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need help on VBA excel macro and API to close an external application 0
Triggering auto_open 5
Importing any excel files with any sheet name into different tables in MSAccess using code 0
ACCDE file not working properly 2
Data Macros Don't Work With Linked Tables??? 21
How can i get vba to get a value from a combobox and make it run a macro 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Using VBA to trigger a certain slide 0

Back
Top