General information
Category:
COM/DCOM and OLE Automation
>I have used the solution below to open an excel spreadsheet, disabling the macros.
>
I'm assuming the problem is that a dialog appears that needs a response. Use:
loExcel.DisplayAlerts = .F.
to prevent the dialog.
As for macros, when you open a workbook by automation, the Auto macros (like AutoOpen) don't fire. So you needn't worry about infecting a machine by having a macro run when you open a workbook.
I'm not sure how to disable the macros, though.
Tamar
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only