| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.word.vba.general
|
|||
|
|||
How do I prevent AutoRun Macros when Programmatically Opening Workbook?
I have an application which uses Word and Excel as automation servers. When
opening a document, I need to prevent macros from running automatically. For Word documents I can do this as follows: m_AppWord.WordBasic.DisableAutoMacros 1 Set m_DocWord = m_AppWord.Documents.Open(CStr(m_Document), False, True, False) What is the equivalent statement for Excel which I should be coding directly before opening the file? Set m_DocExcel = m_AppExcel.Workbooks.Open(CStr(m_Document)) Thanks for your help! - Joseph Geretz |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Disable macros on a programmatically opening .xls file | Excel Discussion (Misc queries) | |||
| how do I prevent a file from opening if user has disabled macros? | Excel Programming | |||
| Disable Macros in workbook programmatically | Excel Programming | |||
| How do I turn off macros when programmatically opening a workbook. | Excel Programming | |||
| autorun code when opening sheet (not workbook) | Excel Programming | |||
Threaded Mode
