Turning off Excel.macros from my Access database

[Mauricio Silva]

I am exporting data from Access to a Pre-formatted spreadsheet created by out
financial group (I cannot change it). They put a macro on the spreadsheet so,
every time we open it, the Excel asks me to enable/disable the macros.

My problem is, when I open the spreadsheet from my VBA routine in Access, it
also asks to enable/disable the macros. Can I turn the macros off from my
Access? Or is there an opion to open spreadsheet from Access with no macros
enabled?

Thanks

Mauricio Silva

 

[John Nurick]

Hi Mauricio,

One approach of course is to lower the macro security level on the
computers in question. Another, at least in Access 2003, is to get them
to sign the preformatted spreadsheet and then to tell the computers to
trust that certificate.

Otherwise, it's more an Excel question than an Access one; I suggest you
ask in microsoft.public.excel.interopoledde or
microsoft.public.excel.programming .