View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bob Barnes[_3_] Bob Barnes[_3_] is offline
external usenet poster
 
Posts: 10
Default AutoExec - Enable Macros

I am an Access Developer using automation to get Access data to Excel

After automation, any cell Borders get zapped. I can code to reset those Border
when entering Excel

My questions -

1 - What is the Macro name to AutoExec (in Lotus 1-2-3 years ago it's \0")

2 - How do I program to stop the "Disable Macros" & 'Enable Macros" opening MsgBox

& 3 - Can I run the "AutoExec" from within Access as"DoCmd.RunMacro...."

TIA - Bo

1 - W