467,116 Members | 1,174 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

Excel Automation

I am an experience VB programmer and have used Excel for years. However, when I tried to use Excel Automation to do a simple job of reading a two column spreadsheet into a VB array, I got stumped. I can't even figure out how to open the workbook. I've look in MSDN for examples and haven't found any relevant ones. I looked in my library of VB and Excel books and found nothing. VB Intellisense is virtually useless in this area. Can someone please send me a few lines of code with annotation showing me how to do this. I am using Visual Basic Express 2005 and Excel 2003.

Thanks
Dan
Nov 11 '06 #1
  • viewed: 1353
Share:
1 Reply
1GB
I am an experience VB programmer and have used Excel for years. However, when I tried to use Excel Automation to do a simple job of reading a two column spreadsheet into a VB array, I got stumped. I can't even figure out how to open the workbook. I've look in MSDN for examples and haven't found any relevant ones. I looked in my library of VB and Excel books and found nothing. VB Intellisense is virtually useless in this area. Can someone please send me a few lines of code with annotation showing me how to do this. I am using Visual Basic Express 2005 and Excel 2003.

Thanks
Dan
You are using vb.NET so answers on this forum may not be accurate.
In vb6 you need to include a reference to excel in the project and intellisense will pick up the objects. You declare an excel app and worksheets etc and away you go.

Happy Excelling :)
Nov 11 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by jeffgeorge | last post: by
17 posts views Thread by Mansi | last post: by
12 posts views Thread by D. Shane Fowlkes | last post: by
3 posts views Thread by Carlos Magalhaes | last post: by
3 posts views Thread by Mitchell Vincent | last post: by
6 posts views Thread by a.theil@surfeu.at | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.