+ Reply to Thread
Results 1 to 2 of 2

enable and run several macro enabled files

  1. #1
    Registered User
    Join Date
    07-27-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007,2010, 2013
    Posts
    26

    enable and run several macro enabled files

    Dear All,

    If I have a folder with around 10 excel files containing a macro, is there a way that I can select them all, enable macro, run macro and save?

    Certainly I have like 15 folders with ten Excel files in each, that's why I am looking for automation.

    Best wishes and thanks in advance.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: enable and run several macro enabled files

    Short answer is, yes. You can.

    Firstly, you'll need a way to select a folder and cycle through each and every file (one at a time)
    Read here on how to do it http://www.thespreadsheetguru.com/th...a-given-folder

    Then you'll need to run a specific type of macro within the opened workbooks.
    For that, you can use the Application.Run method
    e.g. Application.Run 'Workbook A.xlsm'!Macro1

+ 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] Batch copying Macro-enable Excel files with variations in VBA code
    By gbolsta in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-11-2015, 05:09 PM
  2. [SOLVED] security issues or providing security for macro enabled files
    By thara.p24 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 08-12-2014, 05:12 AM
  3. [SOLVED] VBA Tools Reference-Check if enabled + enable if not?
    By mc84excel in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-23-2013, 08:46 PM
  4. Problem linking to macro enabled excel files
    By michelle.best in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 03:04 AM
  5. Replies: 0
    Last Post: 03-15-2012, 04:13 PM
  6. Replies: 1
    Last Post: 03-08-2012, 05:14 PM
  7. Problem emailing macro enabled files to fellow office staff
    By dalewms2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2011, 02:37 PM

Tags for this Thread

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