Open Excel Sheet in Vb.net

Please support our VB.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
Reply

Join Date: Apr 2007
Posts: 5
Reputation: anuragNet is an unknown quantity at this point 
Solved Threads: 0
anuragNet anuragNet is offline Offline
Newbie Poster

Open Excel Sheet in Vb.net

 
0
  #1
Apr 23rd, 2007
Hi,
I am opening a existing xl file in vb.net(form itself).
I have added Component "Microsoft Web Browser" and then using "Microsoft Web Browser" control.
Now to open my excel file, I am writing this simple code on a button click
  1.  
  2. AxWebBrowser1.Navigate("C:\CHIMP\Chimp.xls")
Excel is opening properly
Now Problem: when i clcking on close button of form..its almost hang. I can see Excel.exe is still running in task manager. Once I kill it ...all went well ann my hang form automatically close.
Please suggest what to do as AxWebBrowser1.Navigate is not giving any handler so i dont have further excess.
Regards
Anurag
Reply With Quote Quick reply to this message  
Join Date: Jun 2007
Posts: 1
Reputation: sylvain0000 is an unknown quantity at this point 
Solved Threads: 0
sylvain0000 sylvain0000 is offline Offline
Newbie Poster

Re: Open Excel Sheet in Vb.net

 
0
  #2
Jun 4th, 2007
Hello

You should try this :
  1. AxWebBrowser1.Dispose()
  2. AxWebBrowser1 = Nothing
Regards,
Sylvain
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC