+ Reply to Thread
Results 1 to 1 of 1

Running a macro with arguments from a macro in a different workbook

  1. #1
    Registered User
    Join Date
    11-29-2012
    Location
    Rende, Italy
    MS-Off Ver
    Excel 2003
    Posts
    1

    Running a macro with arguments from a macro in a different workbook

    Hi Guys,
    I have a problem that is gonna make me crazy:

    I want to run from an Excel workbook (let's say MainWorkbook.xls)
    a macro ("RunAll") placed in another workbook ("AllMacros.xls").

    To do that, I wrote the following macro ("OverallRun"):


    ---------------------
    Please Login or Register  to view this content.

    Now, the only thing I get from running "OverallRun" is this error message:

    "The Macro AllMacros.xls!Modulo1.RunAll cannot be found".

    I have to specify that without arguments, the macro "RunAll" start running,
    so the problem should be in the arguments. However, after several attempts,
    I cannot figure out what's wrong with my code.

    Any suggestion? Is it possible that, since the macro "RunAll" is
    not directly visible in the excel menu due to the presence of the
    arguments, it cannot be accessible from outside?

    Thanks to all in advance

    Moderator's Note: Welcome to the forum, this is to inform you about code tags. When posting codes...select the code then hit the "#" sign to wrap it with code tags. Thank you.
    Last edited by vlady; 11-29-2012 at 05:40 AM. Reason: code tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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