|
-
May 21st, 2000, 11:01 AM
#1
Thread Starter
Lively Member
try this
dim x as new excel.application
x = getobject(,"Excel.application")
x = getobject("c:\test.xls")
now try
x.application.sheets("Sheet1").select
x.application.row ..........
or else see Getobject example in vb help
Dim col as Varient, row as Integer
For col = A to Z
For row = 1 to 15
Xl.Range(col,row).Select
'get value and do stuff to it
Next row
Next col
I'm trying very hard but can't find any answers,Thanks in advance.
Joey O. [/B][/QUOTE]
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
|