+ Reply to Thread
Results 1 to 3 of 3

run a macro in the open workbook

  1. #1
    Forum Contributor
    Join Date
    12-16-2006
    Posts
    349

    run a macro in the open workbook

    Please Login or Register  to view this content.

    Each file this code opens has a macro in named "updateraa" i need it to run this before it runs "SET1" how can I do this. IF it type Run "updateraa" macro cannot be found as it is not the workbook the above macro is running in. the updater aa is in the workbook that has been opened by the macro above.
    is it application.run ? or somwthing like that,

  2. #2
    Registered User
    Join Date
    10-01-2007
    Posts
    23
    I just came to this forum to post the same exact question... funny

  3. #3
    Registered User
    Join Date
    10-01-2007
    Posts
    23
    I did a little searching and found a solution

    Try this:

    Application.Run(wb.Name & "!updateraa", 1, 2)
    where 1,2 are your parameters. Remove them if not needed.
    Last edited by paulmezick; 01-04-2008 at 12:27 PM.

+ 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