Results 1 to 2 of 2
Thread: workspace copying (xp)
2003-08-15, 17:25 #1
- Join Date
- Aug 2003
- Thanked 0 Times in 0 Posts
workspace copying (xp)
can you copy workspaces in excel? i have a template folder with a workspace consisting of 2 linked workbooks. i am trying to use this to copy into a new folder (via explorer) for each new project i have. for each new project i apply many changes to this template. for the first try at this, i have found that the data i enter in the new folder (that the template workspace is copied into for future alterations) is automatically updating to my blank template. every time i save my work applied to this new project in a separate folder, it goes back to my template folder and saves it there too. i don't want this blank template to be altered. why is this link occuring and how can i troubleshoot?
2003-08-15, 18:45 #2
- Join Date
- Jul 2002
- Pittsburgh, Pennsylvania, USA
- Thanked 342 Times in 335 Posts
Re: workspace copying (xp)
The "workspace" file is essentially a list of the files that it is supposed to open: It is NOT the files themselves. If you open FIleA, FIleB and FIleC and save the workspace, it becomes a simple way of opening all 3 files by opening just 1 workspace. You could still open and save any of the files individually and it would still work.
If you COPY the workspace file (*.xlw) and give it a new name, unless you EDIT it (and it is NOT straight text, but it does have the file names in text) and I have not played with any way to do this (perhaps it can be manipulated in VB? I haven't tried) you will STILL OPEN the same files as before.
You have to give the workspace a new name and then save ALL the files IN the workspace with new names and then save the workspace.