How to read Excel Spread Sheet in VB

[Shabnam Gupta]

Hello Everyone,
I am working on a project where I have to read an excel
spreadsheet with about 60 cells and rows of data that I
don't need. I want to write out a comma delimited file
with just the information I need. Is there a way to
create a excel object, open the spread sheet and then
read each row and column and strip out just what I need
to a flat file.

Any help is really appreciated.


Thanks
Shabnam

 

[Tom Ogilvy]

Here is a start:

http://support.microsoft.com/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications

The key will be able if you can identify what it is you need and what you
don't.

 

[Shabnam Gupta]

The reply you sent me just works with flat files. I thought to read an
excel workbook you need to create excel.application object and
excel.sheet object. How would you read the cells and rows from these
objects. Thanks for your help.

Shabnam

 

[Tom Ogilvy]

I assumed you were working in Excel, but if not:

http://support.microsoft.com/?id=167223
Microsoft Office 97 Automation Help File Available on MSL


http://support.microsoft.com/support/OfficeDev/FaqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


http://support.microsoft.com/support/OfficeDev/offdevinapps.asp
Programming Office from Within Office

http://support.microsoft.com/support/officedev/iisfaq.asp
Integrating Office with IIS FAQ

http://support.microsoft.com/?id =219151
Q219151 - HOWTO: Automate Excel 97 and Excel 2000 from Visual Basic

http://support.microsoft.com/support/excel/content/Automation/automation.asp
Using Automation with Microsoft Excel 97

http://support.microsoft.com/?id=153748
ACC: How to Call Excel Functions from Within Microsoft Access