VBA formula update?

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!!!
 
B

Ben McClave

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
 
B

Bobby

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!
 
Top