+ Reply to Thread
Results 1 to 2 of 2

Break all links in all workbooks in a folder

  1. #1
    Registered User
    Join Date
    12-09-2011
    Location
    Sioux Falls, South Dakota
    MS-Off Ver
    Excel 2007
    Posts
    46

    Break all links in all workbooks in a folder

    I am trying to use the following code to open a workbook in a folder, break the links, then save and close and move on to the next workbook in the folder until all are finished. If I have read correctly .filesearch may not work in excel 2007, if anyone has any suggestions it would be much appreciated! Thanks.

    Please Login or Register  to view this content.

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Break all links in all workbooks in a folder

    I don't know whether FileSearch works or not in 2007 but I use the Dir function. I modified your code but have not tested it.

    Please Login or Register  to view this content.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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