>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