Running a Macro in Personal.xls from Access

  • Thread starter Thread starter Brent E
  • Start date Start date
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,
 
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,
 
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...
 
Back
Top