Reading xls

[Dragev]

How do I read from an Excel file, with Rich Text, Images and stuff?

D

[joefoulkes]

You'll need to make a reference to 'Microsoft Excel 9.0 Object Library' in your project.

This code should get you on your way.....

Dim ExApp As Excel.Application
Set ExApp = New Excel.Application

' make Excel visible
ExApp.Visible = True
' open the xls file
ExApp.Workbooks.Open "c:\my spreadsheet.xls"

' show the text from cell A1
MsgBox Range("A1").text

Try recording some macros in Excel, that will give you most of the code you'll need to use.

[Dragev]

Thanks, man.
When I set ExApp.Visible to False, it worked almost exactly the way i wanted it to. But still I can't get the pictures that live in the sheet.

D