Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Looking for Excel Content (with Worksheet)

Status
Not open for further replies.

waldemar

Programmer
Nov 15, 2001
245
DE
By trying to append data in some tables, I opened an Excel File like this:

Dim Excel As Object
Set Excel = CreateObject("Excel.application")
Excel.workbooks.Open (strFilename)

Now, I', looking for a way to access speific cells in the way

"Sheet!A1" or
"Sheet!A1:B2"

Through the Cells Property I would need split these "Path-References" in columns and lines (Cells(2,2)). Does anyone know a way of using the complete path like this strContent=Excel.Cells("Sheet!A1") ??

Thanks a lot in advance!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top