+ Reply to Thread
Results 1 to 2 of 2

Macro to open, update links, save then close all files in sub folders

  1. #1
    Registered User
    Join Date
    02-18-2015
    Location
    Wailuku, Hawaii
    MS-Off Ver
    Office 365
    Posts
    5

    Macro to open, update links, save then close all files in sub folders

    Hi All,

    Was looking for some help with a macro. I found the macro below on this forum. I think its what i want but i dont want it opening files in the subfolders' subfolder. I hope that makes sense. I have my parent folder with a bunch of subfolders. Each subfolder has an xlsm file and another subfolder in it. I just want it to open the xlsm file, update links, save and close then move on to the next subfolder of the parent folder.

    Thank you in advance

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 12-03-2015 at 05:38 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Macro to open, update links, save then close all files in sub folders

    So I am guessing that path in the first LoopStarter is the parent folder, no files are opened there. You need the Looper to go down one more folder to find a file, then NOT go any deeper into that one folder?

    In that case I would recommend 3 macros instead of two.

    LoopStarter - what you currently have

    SubFolderFinder - a new macro that is the second part of the current Looper, just the part that finds SubFolders and calls the Looper.

    Looper - just the first half of your current Looper, only the part that loops through files in the one folder.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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] macro to open all files in a folder, save them, then close them
    By hopefulhart in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-27-2013, 06:40 PM
  2. [SOLVED] Macro to open and close all files in a folder and sub folders
    By BillDoor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-31-2012, 06:51 AM
  3. Open Multiple Files to Update - Close & Save with One click
    By awaken88 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2012, 05:24 PM
  4. Macro to Open, Save and Close Excel Files
    By az! in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 04:19 AM
  5. VBA to open, change, save and close all files in DIR
    By jdkoeppen in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-18-2011, 03:35 PM
  6. Macro to open all files, make changes, save and close
    By certain_death in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-20-2009, 03:42 PM
  7. Replies: 2
    Last Post: 02-06-2007, 08:26 AM
  8. [SOLVED] Open Save & Close All Files in Dir
    By Diane Alsing in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-31-2005, 04:06 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