Disabling Error Messages
Hi Jean-Yves,
Yes!
That seems to have solved the problem.
Many Thanks,
ChrisM.
"Jean-Yves" wrote in message
...
Hi Chirs,
from memory
Application.enableEvents=false, just before you open the workbook
will inhibit the firing of the open event
Regards,
Jean-Yves
"ChrisM" wrote in message
...
Hi Group,
I'm just trying for the first time to use the 'Excel Object Library'
from
VB6.
I'm using Excel 2002 (Microsoft Excel 10 Object Library)
I have some code similar to the following:
Dim excelApp As Object 'Excel.Application
Set excelApp = CreateObject("EXCEL.APPLICATION")
excelApp.Visible = False
Call excelApp.Workbooks.Open("c:\temp\SomeExcelFile.xls ", False, True)
My problem is this:
Some of the Workbooks that I need to open may contain some invalid code
modules (I can't do anything about this, I didn't create the Excel
files)
and when the WorkBooks.Open command gets executed, I get a messagebox
from
the App object: 'Compile Error in hidden module : someModule <OK
<HELP'
Does anyone know a way that I can avoid these messageboxes popping up?
(The
fact that there are some compile errors in the code has no bearing on
what
I
am trying to do with this application, so I really want to completly
ignore
them, but if necessary, I don't mind handling the error and doing
somthing
with it, I just don't want these boxes pinging up in the middle of my
application!!)
Thanks,
ChrisM
|