Hutty
Jan 17th, 2000, 11:40 AM
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).]
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).]