S
Steve
I'm using Access 2000 and from a customer form I would like to find the
cust_id on an xls spreadsheet and make that cell the active cell. The code
I'm having trouble with is:
oWkbook = getobject("C:\Customers.xls")
oWksheet = oWkbook.sheets("Addresses")
set c = oWksheet.range("A1:A500").find(me!cust_id, lookin:=xlvalues)
I'm getting an error message about "xlvalues". Any help would be great!
cust_id on an xls spreadsheet and make that cell the active cell. The code
I'm having trouble with is:
oWkbook = getobject("C:\Customers.xls")
oWksheet = oWkbook.sheets("Addresses")
set c = oWksheet.range("A1:A500").find(me!cust_id, lookin:=xlvalues)
I'm getting an error message about "xlvalues". Any help would be great!