+ Reply to Thread
Results 1 to 5 of 5

Run macro update multipule workbooks

  1. #1
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Run macro update multipule workbooks

    In cell 20 is the link where all the files are. In cell 22 is the name of a directory. In cell 21 is the name of the actual file name. So "value of cells" and cell 21 - 29 are the same name. I've attaced a file to better translate what I'm trying to say.

    I would like to open each file minimized and run the macro1, then save and close the file. Bascially - as it is today, I have to open each file and run them manually. I want to just run them all from 1 button
    Attached Files Attached Files
    If we all use our Minds our Heads and our Brains NO TELLING what we could come up with!!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run macro update multipule workbooks

    There's no Macro1 and the button doesn't have a macro assigned to it.

    What is the macro supposed to do?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Run macro update multipule workbooks

    I didn't write a macro. I was explaining what the macro should do. Sorry I wasnt clear.

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Run macro update multipule workbooks

    What should the macro do, beyond opening the files?

  5. #5
    Forum Contributor
    Join Date
    04-23-2007
    Location
    Texas
    Posts
    417

    Re: Run macro update multipule workbooks

    Run macro1 that is inside each of those workbook.

+ 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. VBA copy data from workbook and paste into multipule worksheets/workbooks
    By matium in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 07:19 PM
  2. Update macro path after workbooks moved, renamed
    By jfreeman5 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2011, 03:06 PM
  3. Update links to other workbooks while running macro
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-28-2005, 02:05 AM
  4. Replies: 5
    Last Post: 05-05-2005, 11:06 AM
  5. Replies: 1
    Last Post: 03-31-2005, 05: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