Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoExec - Enable Macros
Hi Bob,
1 Auto_Open() 2 You can't. You need to look into digital signatures. There is a "self cert" tool that come with office. 3 DoCmd is Access. You can use Application.run. There is an example here. http://www.google.com/groups?hl=en&l...20%26hl%3D en Or xlobj.application.run -- John johnf 202 at hotmail dot com "Bob Barnes" wrote in message ... | 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 Borders | 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 - Bob | | 1 - W |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoExec - Enable Macros
Public Sub Auto_Open()
End Sub or in the ThisWorkbook Module, use the Open event Private Sub Workbook_Open() End Sub If opening a workbook manually, In Excel 2000 or later, you can certify your project and if the user (also having xl2000 or later) accepts you as a trusted source, then the next time they open the file there will be no disable - enable macro prompt. oxlApp.Run "Book1.xls!Auto_Open" the open event should run when the workbook is opened, even when opened with code. Auto_Open doesn't run when the workbook is opened with code. -- Regards, Tom Ogilvy Bob Barnes wrote in message ... 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 Borders 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 - Bob 1 - W |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
AutoExec - Enable Macros
John & Tom - I thank both of you.
Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable Macros | Excel Discussion (Misc queries) | |||
how to enable macros | Excel Discussion (Misc queries) | |||
Enable Macros | Excel Worksheet Functions | |||
Suppress the Disable Macros / Enable Macros Dialog | Excel Programming | |||
re-enable macros | Excel Programming |