Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update links using VBA
I have a Excel spreadsheet that needs to be linked to several Excel files
which are always identical in layout but will be renamed and moved to different folders. I have written the macro which re-defines the filepath etc but my problem is that once the links have been re-defined the links will not update unless l take the following steps manually: 1) Edit 2) Links 3) UpdateNow to make matters worst 3) has to be repeated for each link in the list. Can somebody pls tell me or provide VBA code that will automatically update ALL the links ? All help greatly appreciated. Regards Michael Beckinsale |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update Links | Excel Worksheet Functions | |||
Update links | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Update Links | Excel Worksheet Functions | |||
can't update links...can't find links | Excel Discussion (Misc queries) |