Call Excel from VB6 disabling macros

[Derek Hardison via OfficeKB.com]

I can call a workbook from within VB6 get infromation and close the workbook after I have what I need, but my problem is that a macro is setup to call a user form at the opening of this particular excel file, without editing the excel file, can I open it from within vb and disable the macro(s)

 

[Guest]

Yes. Security is at application level, so when you instantiate Excel, set
tsecurity to Medium or High. When the workbook opens, the appl will raise a
messager unless you set DisplayAllerts = False. This will allow the workbook
to open without allowing any code to run. Its designed to prevent malicious
software getting in through Office applications.

Patrick Molloy
Microsoft Excel MVP

 

[Derek Hardison via OfficeKB.com]

First, Thank You, but I understand that and I use the excel workbook I created to keep records, therfore I like the code to run when I open it myself, but when I just want to get select info from the workbook and use it in another application created with VB6, I do not want the excel code to run. You may have answered this but I haven't had any luck with it. Maybe some sample VB6 code would help me?

Thanks again,

Derek

 

[Guest]

Hi Derek,

In your VB6 code, switch off Excel's events before opening the workbook.

eg.

objXL.EnableEvents = False
objXL.Workbooks.Open ...


Regards,
Vic Eldridge