trigger excel macro with VBA

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)
 
C

Clifford Bass

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
 
H

hor vannara

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
Importing any excel files with any sheet name into different tables in MSAccess using code 0
How can i get vba to get a value from a combobox and make it run a macro 0
Find last weekday of the month with vba for all months 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Triggering auto_open 5
PageSetup Macro 1
Object Variable to Control Excel Macro 2

Top