External Link To Other Files

  • Thread starter Thread starter FERDIE
  • Start date Start date
F

FERDIE

i have 3 separate workbooks. Each workbook contains the same structure.
I have defined a standard range name for each workbook called "DATA".
I want to get the data from a particular column for all workbook. I
have used the VLOOKUP function but i want to put the names of the file
to different cells so that it would serve as an argument using the "&"
symbol in the table_array field
VLOOKUP(A4,&B2,4,0)
against
VLOOKUP(A4,'C:\TEMp\TEMP1.xls'!DATA,4,0)

Is there any other way??? I appreciate any help...
Thanks in advance
 
This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/UsingSqlRequest.zip
It's in the "Excel with Access Databases" section on page:
http://www.bygsoftware.com/examples/examples.htm

This workbook demonstrates how to get data direct from an MS Access table,
or from an open or closed MS Excel workbook using the workbook function
SQL.REQUEST.

Recently updated to show the use of SQL.REQUEST in the same workbook.

The code is open and commented.


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"
 
i have 3 separate workbooks. Each workbook contains the same structure.
I have defined a standard range name for each workbook called "DATA".
I want to get the data from a particular column for all workbook. I
have used the VLOOKUP function but i want to put the names of the file
to different cells so that it would serve as an argument using the "&"
symbol in the table_array field
VLOOKUP(A4,&B2,4,0)
against
VLOOKUP(A4,'C:\TEMp\TEMP1.xls'!DATA,4,0)
Click to expand...

This is a syntactically invalid use of the & operator in cell formulas. In Excel
worksheet formulas, & is the dyadic concatenation operator, not a monadic
addressing operator.
Is there any other way??? I appreciate any help...
Click to expand...

http://www.google.com/[email protected]
 
Back
Top