VB to open An Existing Excel Workbook

[Jo15765]

How would I open an existing Excel workbook using VB.Net?

[TysonLPrice]

You should check out the search facilty here...you wouldn't have to wait. I just grabbed this from what came back. There is more:

http://www.vbforums.com/showthread.p...Excel+workbook

[Crzyrio]

How would I open an existing Excel workbook using VB.Net?

Do you want to open it in a vb form or in Excel?

If you want to do it in excel,

Imports Microsoft.Office.Interop
 
Public Class Form1
 
    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
 
        Dim xls As Excel.Application
        Dim workbook As Excel.Workbook
        xls = New Excel.Application
 
        xls.Visible = True
 
        workbook = xls.Workbooks.Open("C:\...")
 
    End Sub
End Class

http://support.microsoft.com/kb/301982



If you want to open it in the form it self, your best bet is to use the Webbrowser control to open the file

[Jo15765]

Thank you for the sample coding Crzyrio...however, on the line that reads

xls = xls.Workbooks.Open("")

[Crzyrio]

Thank you for the sample coding Crzyrio...however, on the line that reads

xls = xls.Workbooks.Open("")

What happens on that line? The path of your excel document goes there.

EDIT: My Mistake, this will work for sure. You need a workbook object when opening a workbook :P

Imports Microsoft.Office.Interop
 
Public Class Form1
 
    Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
 
        Dim xls As Excel.Application
        Dim workbook As Excel.Workbook
        xls = New Excel.Application
 
        xls.Visible = True
 
        workbook = xls.Workbooks.Open("C:\...")
 
    End Sub
End Class

[Jo15765]

I get a compile error of Cannot implicitly convert type Microsoft.Office.Interop.Excel.Workbook to Microsoft.Office.Interop.Excel.Application. An explicit conversion exists (are you missing a cast?)

[Crzyrio]

I get a compile error of Cannot implicitly convert type Microsoft.Office.Interop.Excel.Workbook to Microsoft.Office.Interop.Excel.Application. An explicit conversion exists (are you missing a cast?)

I updated the code in both my post, take another look at it.

Was supposed to use the Excel.workbook object to use xls.Workbooks.Open, rather than the Excel.Application object.

[TysonLPrice]

Worked for me...

[Jo15765]

I get a System.Runtime.InteropServices.COMException Debug error

[TysonLPrice]

You do have Excel on your computer right?

[Jo15765]

Haha...yes. I have Excel 2007 & Excel 2010 installed on this machine.

[Crzyrio]

Haha...yes. I have Excel 2007 & Excel 2010 installed on this machine.

Did you copy paste the exact code? Check if there are any spaces in your filepath name, that can cause problems sometimes.


Which reference did you add in order to use this? There is a 12.0 Object Library and a 5.0 Library, I am using the 12.0 Library with Excel 2007.

Does the code compile? At what point do you get the error.

[Jo15765]

Yes, I copied and pasted the code exactly as it appears.
I added a reference to the Microsoft Excel 12.0 Object Library -- and this is a COM reference
The code compiles fine, it produces the error when it reaches this line

xlWorkBook = xlApp.Workbooks.Open....

[TysonLPrice]

Please post the entire line. Not just

xlWorkBook = xlApp.Workbooks.Open....

[Jo15765]

Full line reads

xlWorkBook = xlApp.Workbooks.Open("C:\\Excel\\Data\\Reports\\Daily.xls");

[TysonLPrice]

That's new to me but that doesn't mean a whole lot. I would have used:

xlWorkBook = xlApp.Workbooks.Open("C:\Excel\Data\Reports\Daily.xls");

The version of Excel I'l using creates .xlxs extentions also. Still works with the older stuff though.

[Jo15765]

That's interesting a single slash compiles on your end. When I try a single slash I get a compile error of 'Unrecognized Escape Sequence'

[TysonLPrice]

That's interesting a single slash compiles on your end. When I try a single slash I get a compile error of 'Unrecognized Escape Sequence'

Wrapped in double quotes? The compiler should just see a string right?

[dunfiddlin]

That's interesting a single slash compiles on your end. When I try a single slash I get a compile error of 'Unrecognized Escape Sequence'

What version of VB are you using?

[TysonLPrice]

OK...I'm going to try and save you some headaches down the road based on I think you are new to manipulating Excel based on your post. Closing and disposing of Excel is just as important as opening it. After running the application and few times and getting odd errors you'll notice in task manager multiple versions of Excel running. That means it wasn't cleaned up properly. Search this site for "Excel keeps running in task manager" for some solutions.

[Crzyrio]

Wrapped in double quotes? The compiler should just see a string right?

This might be a dumb question but just to double check, your not in C# are you?

OK...I'm going to try and save you some headaches down the road based on I think you are new to manipulating Excel based on your post. Closing and disposing of Excel is just as important as opening it. After running the application and few times and getting odd errors you'll notice in task manager multiple versions of Excel running. That means it wasn't cleaned up properly. Search this site for "Excel keeps running in task manager" for some solutions.

And this. I found out the hard way when I first started, had close to 30 Word processes open and had no idea :P

[TysonLPrice]

This might be a dumb question but just to double check, your not in C# are you?




And this. I found out the hard way when I first started, had close to 30 Word processes open and had no idea :P

I wrote a program to close them all until I finally got it straight

[Jo15765]

I am working with a VB project...but thanks for checking ....
I just rebooted to see if there were any lingering instances of Excel going that could be causing my peculiar error, but alas, even after a clean start my coding is still producing that same error.

[TysonLPrice]

Post what you are running just like Crzyrio did for you...

[Jo15765]

I am running that exact code, I copied/pasted it into my Visual Studio to see if it would work for me

[TysonLPrice]

OK...good luck to you.

[Crzyrio]

Try this :P

Paste it into a form load or a button

Microsoft.Office.Interop.Excel.Application oXL;
            Microsoft.Office.Interop.Excel._Workbook oWB;
 
 
            oXL = new Microsoft.Office.Interop.Excel.Application();
 
            oXL.Visible = true;
 
            oWB = oXL.Workbooks.Open("C:\\...");

I wrote a program to close them all until I finally got it straight

Never thought of doing that! lol

[TysonLPrice]

I am running that exact code, I copied/pasted it into my Visual Studio to see if it would work for me

Well that explains it. Change:

workbook = xls.Workbooks.Open("C:\...")

to point at your file.

You might be better served by reviewing this tutorial:

http://vb.net-informations.com/

Go to the section on VB.NET Excel 2007 Tutorials.

Last time I was there all the examples worked as posted. I'm on VS 2012 some some tweaks were needed but it will give you a bigger picture.

Also look at:

http://www.vbforums.com/showthread.p...6-(or-VB5-VBA)

It is VB 6.0 but the principles are the same.

[Siddharth Rout]

THIS would get you started. Let me know if you are still facing problems...