+ Reply to Thread
Results 1 to 3 of 3

How do I break links on workbook after saved in subfolder

  1. #1
    Forum Contributor
    Join Date
    08-02-2005
    Location
    LONDON
    MS-Off Ver
    OFFICE365
    Posts
    114

    How do I break links on workbook after saved in subfolder

    Hi

    I was given this macro and ive amended but just trying to finish off.


    It saves the active workbook as a copy called summary1.xls in a new subfolder created. What im trying to do is break the links in the new summary1.xls after it saved to new location.


    Can this be done?


    Please Login or Register  to view this content.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    27,951

    Re: How do I break links on workbook after saved in subfolder

    Hi

    Data------Edit Links-----Break Links

    Incidentally, would you add your Location and Software versions. It's often helpful when we need to consider stuff like regional settings and date formats.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Valued Forum Contributor
    Join Date
    09-19-2008
    Location
    Earth
    MS-Off Ver
    2016
    Posts
    692

    Re: How do I break links on workbook after saved in subfolder

    Try:
    Please Login or Register  to view this content.
    where FullPathAndFileName is the path & file name of the file you reference ... so T:\Passenger ... etc etc ... plus the \filename.

    MM.
    MatrixMan.
    --------------------------------------
    If this - or any - reply helps you, remember to say thanks by clicking on *Add Reputation.
    If your issue is now resolved, remember to mark as solved - click Thread Tools at top left of thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I break links in a workbook?
    By Alwebster6635 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  2. [SOLVED] How do I break links in a workbook?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 11:05 AM
  3. [SOLVED] How do I break links in a workbook?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  4. How do I break links in a workbook?
    By Dave Peterson in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 04:05 AM
  5. How do I break links in a workbook?
    By Alwebster6635 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  6. [SOLVED] How do I break links in a workbook?
    By Alwebster6635 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  7. [SOLVED] How do I break links in a workbook?
    By Alwebster6635 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  8. How do I break links in a workbook?
    By Alwebster6635 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-21-2005, 03:05 PM

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