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