I am trying to do vlookup in a macro. Is there any way I can specify
table from a sheet in a workbook that is not open for second argumen
of vlookup?

For this format
ActiveCell.FormulaR1C1 = _

"=VLOOKUP(RC4,[current_file.xls]overall!R2C1:R1000C15,4,FALSE)"
I have to have current_file.xls open

It gave me errors when I tried this

ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC4,[E:\folder 1\folde
2\current_file.xls]overall!R2C1:R1000C15,4,FALSE)"

What is the correct syntax to specify this file in vlookup so that
dont have to have that file open?

Thanks,
Ja

--
sa0200
-----------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=47557