Running a Macro in Personal.xls from Access

B

Brent E

Thanks, Ken.

I have another question for you. I am trying to figure out the code to run a
macro stored in the Personal.xls file from an Access module.

I tried the follwing but got an error that Personal.xls can't be found.
Please advise.

Application.Run "PERSONAL.xls!Database_Update_ Files"

Thanks,
 
B

Brent E

This is more of the VBA in context.
Dim objExcel As Object

Set objExcel = CreateObject("Excel.Application")

objExcel.Application.Run "PERSONAL.xls!Database_Update_POLS_PROS_BPIS_Files"

End Function

Thanks,
 
L

leticia

Brent E said:
Thanks, Ken.

I have another question for you. I am trying to figure out the code to run
a
macro stored in the Personal.xls file from an Access module.

I tried the follwing but got an error that Personal.xls can't be found.
Please advise.

Application.Run "PERSONAL.xls!Database_Update_ Files"

Thanks,
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

Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Call Macro from PERSONAL.XLS 4
Digitally Signed Macros in Personal.XLS 3
error message : I can't close my PERSONAL.XLS file 2
personal.xls 2
Run Excel macro with arguments from Access 3
Run macro in workbook from PERSONAL.XLS 1
Run Excel Macro from Access and save changes to .CSV format 4

Top