External Link To Other Files

[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

 

[Andy]

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"

 

[FERDIE]

Thanks guys....