Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to update links
I have a file (a) that has links to another file (b) which is in a
defined format. Each month this file (b) is updated and renamed file (c) and it is now this most current version of the file that file (a) needs to link to Is there a macro that can be run to update link names? I am quite a novice so would appreciate the code. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to update links
Clare,
What kind of links do you have from file a to file b? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to update links
Thanks for the question
Currently the link is a cell saying ='S:\FILE\Finance\06 June\[0606MainSchedules FINAL.xls]I&E Summary'!$P$10 (File b = [0606MainSchedules FINAL.xls]) I wanted to be able to write a macro that enables me to link to the next months file automatically, so for month 7 it will be as below ='S:\FILE\Finance\07 July\[0706MainSchedules FINAL.xls]I&E Summary'!$P$10 I had thought I would be able to require users to complete of 2 cells - 1 with the old link and 1 with the new link to be updated to & then run a macro so change the links (these could be populated from a drop down list) Unfortunately I'm having trouble recording such a macro llama wrote: Clare, What kind of links do you have from file a to file b? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
A macro to update links
I have sent an example file to your hotmail account. Hope it helps
Paul theaccountant wrote: Thanks for the question Currently the link is a cell saying ='S:\FILE\Finance\06 June\[0606MainSchedules FINAL.xls]I&E Summary'!$P$10 (File b = [0606MainSchedules FINAL.xls]) I wanted to be able to write a macro that enables me to link to the next months file automatically, so for month 7 it will be as below ='S:\FILE\Finance\07 July\[0706MainSchedules FINAL.xls]I&E Summary'!$P$10 I had thought I would be able to require users to complete of 2 cells - 1 with the old link and 1 with the new link to be updated to & then run a macro so change the links (these could be populated from a drop down list) Unfortunately I'm having trouble recording such a macro llama wrote: Clare, What kind of links do you have from file a to file b? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update links macro | Excel Programming | |||
update links when Macro ends | Excel Programming | |||
Excel Macro - Auto Update Links | Excel Programming | |||
Macro after Update of Links | Excel Programming | |||
How do I set up a macro to automatically update links upon openin. | Excel Programming |