+ Reply to Thread
Results 1 to 2 of 2

Break all links in all workbooks in a folder

  1. 11-01-2012, 11:42 AM #1
    jharaldson
    jharaldson is offline
    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.
    Reply With QuoteRegister To Reply
  2. 11-01-2012, 08:56 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,885

    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1