+ Reply to Thread
Results 1 to 3 of 3

Worksheet copy issue

  1. #1
    Registered User
    Join Date
    07-25-2005
    Posts
    62

    Worksheet copy issue

    I am building a report creator which creates a new workbook for the data every fiscal week. The problem is, when I copy a worksheet to the new workbook from the template workbook the references still point to the old workbook (i.e. =Data!B3 becomes =[Audits.xls]Data!B3) is there some easy way to prevent this? I used the replace method to remove all the ["oldFileName"] instances but this is clumsy.

    Thanks,
    Tommy
    Last edited by TommySzalapski; 07-25-2005 at 12:47 PM.

  2. #2
    Barb
    Guest

    RE: Worksheet copy issue

    Hi Tommy
    Go to Edit Links and link the book to itself.

    Thanks
    Barb

    "TommySzalapski" wrote:

    >
    > I am building a report creator which creates a new workbook for the data
    > every fiscal week. The problem is, when I copy a worksheet to the new
    > workbook from the template workbook the references still point to the
    > old workbook (i.e. =Data!B3 becomes =[Audits.xls]Data!B3) is there some
    > easy way to prevent this? I used the replace method to remove all the
    > ["oldFileName"] instances but this is clumsy.
    >
    > Thanks,
    > Tommy
    >
    >
    > --
    > TommySzalapski
    > ------------------------------------------------------------------------
    > TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
    > View this thread: http://www.excelforum.com/showthread...hreadid=389934
    >
    >


  3. #3
    Registered User
    Join Date
    07-25-2005
    Posts
    62
    No, I need to do it from within the macro

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1