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

I will give it a try!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top