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