VBA formula update?

  • Thread starter Thread starter Bobby
  • Start date Start date
B

Bobby

Hi,
I am trying to change with VBA this formula:
=VLOOKUP("total 53",'C:\AmelCont\Julie\[Tableau et Graphique RP Fruits 2011-2012.xls]TAB Fast_Source Fruits'!$A$7:$I$6000,6,0

TO

=VLOOKUP("total 53",'C:\AmelCont\Julie\[Tableau et Graphique RP Fruits 2012-2013.xls]TAB Fast_Source Fruits'!$A$7:$I$6000,6,0

CHANGING YEARS. I have set:
Application.ScreenUpdating = False
Application.Calculation = xlManual
Application.EnableEvents = False

The problem is it a pop up menu to UPATE comes up to locate the new file name!
CAN I STOP THIS POP UP?
Thank's ahead!!!
 
Bobby,

It might be easier to Edit your Links. In 2010 go to Data > Edit Links and select the file name that is changing. Then click "Change Source" and browse to the new file name. This will change the file reference throughout the workbook.

Ben
 
Bobby,



It might be easier to Edit your Links. In 2010 go to Data > Edit Links and select the file name that is changing. Then click "Change Source" and browse to the new file name. This will change the file reference throughout the workbook.



Ben
Click to expand...

I will give it a try!
 
Back
Top