t;
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can, At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
>*From:* Nitin Balodi
> *To:* "exce
Hi Paul and Vaibhav,
Thanks, it worked by giving spaces.
Regards.
Yours Sincerely,Nitin Balodi
Date: Mon, 25 Aug 2014 05:45:45 -0700
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
The syntax error is probably because
can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Nitin Balodi
>To: "excel-macros@googlegroups.com"
>Sent: Monday
Hi Vaibhav,
I had used this but it is still showing syntax error.
Regards.
Yours Sincerely,Nitin Balodi
From: v...@vabs.in
Date: Mon, 25 Aug 2014 17:45:09 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
To: excel-macros@googlegroups.com
try:
ActiveCell.FormulaR1C1
.FormulaR1C1 = _
> "=VLOOKUP(RC[-3],'["&wrkbk&"]Sheet1'!C1:C8,8,0)"
>
>
> Value of WrkBk is *ForecastLastUpdated_18 July 2014 15.45.xlsx*
>
>
> Regards.
>
> Yours Sincerely,
> *Nitin Balodi*
>
>
> -------
itin Balodi
Date: Mon, 25 Aug 2014 16:25:31 +0530
Subject: Re: $$Excel-Macros$$ VLookup file reference using VBA
From: v...@vabs.in
To: excel-macros@googlegroups.com
Hi
Use:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'["&wrkbk&".xlsx]Sheet1'!C1:C8,8,0)"
In order to understand what you're doing and work through your question,
you need to understand what VBA is doing.
Your VBA line:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'[ForecastLastUpdated_18 July 2014
15.45.xlsx]Sheet1'!C1:C8,8,0)"
is essentially :
ActiveCell.FormulaR1C1 = "some strin
Hi
Use:
ActiveCell.FormulaR1C1 = _
"=VLOOKUP(RC[-3],'["&wrkbk&".xlsx]Sheet1'!C1:C8,8,0)"
Cheers
On Aug 25, 2014 4:18 PM, "Nitin Balodi" wrote:
> Hi All,
>
>
>
> I have two files: File1 and File2.
>
>
>
> I need to apply Vlookup in File1 using references from File2.
>
> I have stored n
