+ Reply to Thread
Results 1 to 4 of 4

Execute Excel Macro in All Excel Files in a Folder

  1. #1
    Registered User
    Join Date
    04-11-2009
    Location
    Toronro
    MS-Off Ver
    Excel 2003
    Posts
    15

    Execute Excel Macro in All Excel Files in a Folder

    Hi Everyone,

    Hope everyone is doing well.

    I found the following code to execute a macro in all excel files in a folder. Sounds amazing!

    I have a code to add to it, (thanks again JB!), however I am having issues getting it to work.

    If someone could please take a look at it and let me know what (more like, how many things) I have done wrong, it would be greatly appreciated.

    I am adding this to the Sheet 1 Worksheet.

    As usual, thanks in advance.

    Please Login or Register  to view this content.
    In all honesty, this is a bit overwhelming for me.
    Last edited by salventuro; 04-25-2009 at 12:16 PM. Reason: I don't think I can explain the issue in enough detail, to warrant a response. Thanks anyway. Love this forum!

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: Execute Excel Macro in All Excel Files in a Folder

    you need inverted commas around your path as a starter

    sPath = "C:\Documents\MyDocuments\looptest"

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Execute Excel Macro in All Excel Files in a Folder

    It appears that you have pasted code into yor code, including

    JB's code <- this will error - not code needs apostrophe in frot
    Option Explicit <- should be before any code
    Sub DeleteDoc68()<-should not be included in code, no End Sub precedes it
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    04-11-2009
    Location
    Toronro
    MS-Off Ver
    Excel 2003
    Posts
    15

    Re: Execute Excel Macro in All Excel Files in a Folder

    Thank you royUK and Mallycat.
    Hope you are both having a great day.

    I have followed the instructions you provided, I must be missing something.
    Running the code to open and close all the workbooks runs fine, I can see all the workbooks in the specified open and then close, (which was to cool, to see for the first time), but, the code that I added (JB's code) does not execute.


    Option Explicit <- should be before any code
    I see Option Explicit in the VBA window, at the top of the page.
    Am I to add Option Explicit again somewhere? I have tried to add it in various places, to no avail.

    P.S. I love STUUUUUPER DUCK!

    Here is what it looks like now.
    Sorry, for probably missing the obvious.
    Thanks for your time and instructions, again.



    Please Login or Register  to view this content.

+ 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