vlookup Excel 2003 vba macro different books in different folders

[cometorta]

Hi,

I need some help please with the following.

I want to be able to open workbook 1 and 2 and run a macro in workbook1

The Macro needs to do the following:

For all currently open workbooks except for workbook 1 the macro needs to vlookup the value A1 of Workbook 2 in a the table array A1:B1 in the not open workbook 3 which resides into a diferent folder location than workbooks 1 and 2.

How do I specify the specific location of my workbook which contains the values to be look up?

Thanks in advance,

Francisco

 

[ravishankar]

HI
Give these a try

Cells(1, 3) = "=Vlookup([workbook2.xls]Sheet1!A1,'C:\Imports\Coffee\[workbook3.xls]Sheet1'!A2:F100,3,false)"

or

Dim x as string
x = Application.WorksheetFunction.VLookup(Workbooks("Workbook2.xls").Worksheets("sheet1").Range("A1"), "C:\Imports\Coffee\" & Workbooks("workbooks3.xls").Worksheets("Sheet1").Range("A1:F100"), 3, False)

Ravi