|
-
October 15th, 2001, 03:42 PM
#1
Differences between CreateObject(..) and GetObject(..)
I try to read an Excel document using this: set ExcelSheet = GetObject (strFileName, "Excel.Sheet")
and that :
data = ExcelSheet.Application.Cells(x, y).Value
But this does not work while trying to get values into "data" variable. Why ?
The followin code
set ExcelSheet = CreateObject("Excel.Sheet")
allow me to do this but I can't open the document I want. Any suggestion ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|