Open Excel Sheet in Vb.net

Expand Post »

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

VB.NET Syntax (Toggle Plain Text)
 
AxWebBrowser1.Navigate("C:\CHIMP\Chimp.xls")
 
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

Similar Threads

Open Excel file from Visual Basic in Visual Basic 4 / 5 / 6
Retriving data from excel sheet into an asp page in ASP
Open Excel Sheet in Vb.net in VB.NET
1 .Exporting data from Dataset to XLl sheet in VB.net Windows Application &vice versa in VB.NET
To Fetch EXCEL sheet values thro' ASP page. in Configuring Readymade Scripts

anuragNet

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Apr 2007

Permalink

Jun 4th, 2007

Re: Open Excel Sheet in Vb.net

Hello

You should try this :

VB.NET Syntax (Toggle Plain Text)
AxWebBrowser1.Dispose()
AxWebBrowser1 = Nothing
AxWebBrowser1.Dispose()
AxWebBrowser1 = Nothing

Regards,
Sylvain

sylvain0000

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in VB.NET Forum Timeline: Tutorial

Next Thread in VB.NET Forum Timeline: using sound as reminder

DaniWeb Message

Cancel Changes

User Name
Password