Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: GETOBJECT function provokes context messages. HELP NEEDED


Message #1 by jjacquet@i... on Mon, 13 Aug 2001 14:47:18
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


  Return to Index