VB to open An Existing Excel Workbook

[Jo15765]

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

[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.