|
-
Jan 17th, 2000, 12:40 PM
#1
Thread Starter
Addicted Member
How do I retrieve a value in VB6.0 from an excel file?
The code below doesn't work. Thanks!
Dim objexcel As Excel.Application
Dim cellval As Variant
Set objexcel = New Excel.Application
objexcel.Workbooks.Open ("p:\alico bylines.xls")
objexcel.Visible = True
Set cellval = objexcel.Range("antilles region_ytd!b8").Value
[This message has been edited by Hutty (edited 01-17-2000).]
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
|