I need to retrieve values from an external spreadsheet table, but this table
is variable (one of many). Can anyone help with specifying a variable table
array name??
Example :
field1 = 1
dbname = vlookup(field1;internal_table;fieldindex) -->result = "DataArea2"
(or DataArea3 etc)
I need to access DataArea2 (or DataArea3 etc) in C:\WORK\external.xls, which
is an external spreadsheet...
field2 = "something"
my_problem=vlookup(field2;'C:\WORK\external.xls'!&dbname;otherfieldindex)
How can I stuff the contents of variable dbname in the VLOOKUP syntax??
Bookmarks