using variable names in VLOOKUP

[Guest]

I am using a line of code that uses a variable to look at a set sheet and it
works great. The "TwoMonthsAgo" variable is what I am using to look at a
sheet named "Sep04"

Activecell.formulaR1C1 = "=VLOOKUP(RC1, ' " & TwoMonthsAgo & " ' !C1:C[82],
82, FALSE)"

Now I have another variable "TrendFile" that is the name of the workbook
that the "Sep04" sheet is in. The problem I am having in setting up the
VLOOKUP function from another workbook. I would like to be in workbook-A and
look at the "TrendFile" workbook on sheet "TwoMonthsAgo".

Thanks for any help you can give.

 

[Bob Phillips]

Hi Tony,

Activecell.formulaR1C1 = "=VLOOKUP(RC1, ' " & "['" & TrendFile & "]" &
TwoMonthsAgo & " ' !C1:C[82],
82, FALSE)"