View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Steve D Steve D is offline
external usenet poster
 
Posts: 22
Default Links - Copy a Workbook to another Directory

Good Afternoon,
I have inherited a file that has a number of links to other files. Each
month the file is copied and a new version is pasted in a new folder (ie.
C:/July/July File.xls, C:/August/August File.xls) The file has links that
refer to another file in the old folder that need to remain but when the file
is copied it changes the link from C:/July/July LinkedFile.xls to
C:/August/July LinkedFile.xls. Is there any way to avoid this from happening?
Any help would be greatly appreciated.
--
Thank You,
Steve