| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening a workbook containing macros from VB
I am trying to open an Excel workbook that contains macros
from Access97 VB. I use the coding: Set MyExcel = CreateObject("Excel.Application") With MyExcel .Workbooks.Open pathname & "Book1.xls" to open the file, but I keep getting an error that the method is invalid. Does anyone know how to open an Excel file that contains macros using VB and be able to enable the macros and use them? Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop blank workbook from opening when opening an existing | Excel Discussion (Misc queries) | |||
| Excel 09 File containing macros is not opening | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| when opening an Excel Workbook, another blank workbook also opens | Excel Discussion (Misc queries) | |||
| Macros Disabled when opening file | Excel Discussion (Misc queries) | |||
Threaded Mode
