Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2003
    Posts
    16
    Thanks
    0
    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?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    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.

    Steve

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •