pro_vb thread: GETOBJECT function provokes context messages. HELP NEEDED
Hello,
I have a big problem with the GetObject method. I have to call an Excel
object which is systematically linked to another spreadsheet which doesn't
exist anymore.
As a consequence, everytime I invoke the getobject method, an context
excel message appears and freezes the execution of my application.
Can you tell me how to get rid of those context message from my vb
application ?
Tnx,
Julien
I tried those but they didn't work:
Dim xlApp as object
Set xlSheet = GetObject("C:\Documents and
Settings\Administrator\Desktop\html\Gs1sslg.xlw", "Excel.sheet")
xlApp.Application.EnableEvents = False
xlApp.Application.DisplayAlerts = False