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!
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!