Auto Update Links
 

Hi all,

There are a number of posts on this thread however mine has added
complication.

In short Im trying to get Excel to updates links every time a macro is
run (activated by button), no hassle there.
My problem is the filename (link) will change every month hence I cant
write this into the macro code. Filenames will basically only change
by month name ie:
January_MPC
February_MPC
March_MPC
etc

The simple solution would be to link to a consistant file but as I dont
have control of the link file this isnt an option.
Any assistance or advice would be greatly appreciated.

Regards,

Adrian