Using VB.net to read cell data from Excel 97

G

Guest

I am new to VB.net, I know how to make command buttons and text boxes on a VB
form. I need help with writing the code to ope and Excel 97 spreadsheet and
place a cell data (A1) into my VB.net textbox. How do I code to open a Excel
file and then read a cell's contents??
 
P

Paul Clement

¤ I am new to VB.net, I know how to make command buttons and text boxes on a VB
¤ form. I need help with writing the code to ope and Excel 97 spreadsheet and
¤ place a cell data (A1) into my VB.net textbox. How do I code to open a Excel
¤ file and then read a cell's contents??

See the following example:

How to automate Microsoft Excel from Visual Basic .NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;301982


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need some help in translating from VB4 to VB.NET 9
Excel Paste and VB.NET 1
Can't close EXCEL from VB.NET 8
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Can someone help me re-write VB4 to VB.NET? 2
Read hyperlink in excel sheet in VB.net 2
Excel Question on Formatting Cell and Adding a Row in Excel 2013 1
reading excel data through vb.net application 1

Top