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

Re: Open Excel Sheet in Vb.net
 

Hello

You should try this :

AxWebBrowser1.Dispose()

AxWebBrowser1 = Nothing

Regards,
Sylvain