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...aqVBOffice.asp
Frequently Asked Questions about Microsoft Office Automation Using Visual
Basic


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

http://support.microsoft.com/support...dev/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...automation.asp
Using Automation with Microsoft Excel 97

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

--
Regards,
Tom Ogilvy

"Shabnam Gupta" wrote in message
...


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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!