Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Programmatically open XLT for edit and stop macros
Using Office 2003 and Windows XP;
I have a template file that I need to open for editing using automation (late binding) and in doing so, I want to programmatically prevent macros from firing. My code so far: Dim oXL as Object Dim oWB as Object Dim sFullName = "fully qualified path to my file.xlt" Set oXL = CreateObject("Excel.Application") Set oWB = oXL.Workbooks.Open(sFullName) Can someone please post example code and/or modify my code to achieve this? Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VSTO and Excel-- End Cell Edit Mode Programmatically? | Excel Programming | |||
How to stop file open macro prompt after deleting all macros? | Excel Worksheet Functions | |||
How to edit VB code programmatically | Excel Programming | |||
How to stop having to re-assign macros every time you open a workbook??? | Excel Programming | |||
Programmatically open / edit vba-editor | Excel Programming |