Disable Macros of File your opening

[dgrimm]

I was wondering if there is a way to disable macros in a file that you opening via vba to get data out of? If so what would the macro look like???

Thanks

Dave

 

[Jaafar Tribak]

What code do you have ?
Also,are you just trying to skip the VBA code that is inside the Workbook_Open event of the opened workbook ?

 

[nightcrawler23]

Or you can disable the macros in the trust center settings

 

[shg]

Disable events before opening the workbook.