954,206 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

Open Excel Sheet in Vb.net

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

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

anuragNet
Newbie Poster
5 posts since Apr 2007
Reputation Points: 10
Solved Threads: 0
 

Hello

You should try this :

AxWebBrowser1.Dispose()
AxWebBrowser1 = Nothing

Regards,
Sylvain

sylvain0000
Newbie Poster
1 post since Jun 2007
Reputation Points: 10
Solved Threads: 0
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You