View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter Huang Peter Huang is offline
external usenet poster
 
Posts: 115
Default hang when formula bar open

Hi

You may try to take a look at the link below.

Considerations When Using the WebBrowser Control
The WebBrowser control navigates to documents asynchronously. This means
that when you call WebBrowser1.Navigate, the call returns control to your
Visual Basic application before the document has been completely loaded. If
you plan on Automating the contained document, you need to use the
NavigateComplete2 event to know when the document has finished loading. Use
the Document property of the WebBrowser object passed in to get a reference
to the Office document object, which, in the preceding code, is set to
oDocument.

How To Use the WebBrowser Control to Open an Office Document
http://support.microsoft.com/default...B;EN-US;243058

Also you may try to move the code that open the office document into the
command1_click, because in the form_load the vb6 is initializing the form's
status, which may cause problem, or you may try to call DoEvents in the
end of the form_load.

You may have a try and let me know the result.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.