purplereine
New Member
- Joined
- Sep 18, 2014
- Messages
- 1
Excel 2013
Hi, I'm trying to create a data gatherer template; so it's like a master file that users can just copy and save in a different folder where the rest of the files where the data will be pulled from will be saved.
What I need to have the VBA do is replace all the default links within the data gatherer to the directory where the files are saved when the user opens the file.
This is an example of a link that I currently have in the data gatherer; I'll need this portion
=IFERROR(IF('C:\Users\purplereine\Desktop\Calibrations\01 September\Week_of_Sep_08\[01.xlsm]Breakdown'!$H$4="","",'C:\Users\purplereine\Desktop\Calibrations\01 September\Week_of_Sep_08\[01.xlsm]Breakdown'!$H$4),"")
Hi, I'm trying to create a data gatherer template; so it's like a master file that users can just copy and save in a different folder where the rest of the files where the data will be pulled from will be saved.
What I need to have the VBA do is replace all the default links within the data gatherer to the directory where the files are saved when the user opens the file.
This is an example of a link that I currently have in the data gatherer; I'll need this portion
'C:\Users\purplereine\Desktop\Calibrations\01 September\Week_of_Sep_08\
to change to the current directory=IFERROR(IF('C:\Users\purplereine\Desktop\Calibrations\01 September\Week_of_Sep_08\[01.xlsm]Breakdown'!$H$4="","",'C:\Users\purplereine\Desktop\Calibrations\01 September\Week_of_Sep_08\[01.xlsm]Breakdown'!$H$4),"")
