I run the following code to open up a macro from access to excel:
Set appxcelA1 = GetObject(Full_macro1)
appxcelA1.Application.Run "'" & Full_macro & "'" & "!fixheaders"
Then it runs an excel macro to change the date on the custom print headers for each sheet. When i run on my computer it...