+ Reply to Thread
Results 1 to 2 of 2

Call a Macro in the Active Workbook from a Personal.xlsb procedure [RESOLVED]

  1. #1
    Registered User
    Join Date
    07-30-2013
    Location
    Italy
    MS-Off Ver
    Excel 2010 + 2013
    Posts
    2

    Call a Macro in the Active Workbook from a Personal.xlsb procedure [RESOLVED]

    The code to call a macro in another workbook or the personal.xlsb is fairly easy, for example

    Application.Run ("Personal.xlsb!Bubble")

    Have build a large library of universally running macros [project specific though], that process all sorts in the active project related workbooks. The crux I'm struggling with is: Some project workbooks have certain customizations [in name the same, but executing quite differently]. These are captured in the workbook specific macros. I'd like to call these from the general purpose macros in the personal.xlsb, but for the life of it, can't find anything on this, either because my search phrases are not precise enough, or it's simply a 'not-done' practice. Silly workaround has been to start a macro in the workbook to call the macros in personal.xlsb, but anytime some module is added to personal, have to go through all workbooks to adept the macros there too.

    Any hint most welcome.

    BTW, the names of the workbooks change all the time, so using ActiveWorkbook. to pass variables back and forth which procedures in personal can use.
    Last edited by Seke; 08-15-2015 at 06:20 AM. Reason: Mark Resolved

  2. #2
    Registered User
    Join Date
    07-30-2013
    Location
    Italy
    MS-Off Ver
    Excel 2010 + 2013
    Posts
    2

    Re: Call a Macro in the Active Workbook from a Personal.xlsb procedure [RESOLVED]

    Found the pointer in a stumble upon discussion how to launch a macro from one workbook in another. As 'Personal.xlsb", now set with reference "PersonalBook", is a workbook too, the straight line turned out to be

    PHP Code: 
    Application.Run ActiveWorkbook.Name "!ImageGen" 
    Where ImageGen in the example is a customized procedure in each of the workbooks. Whatever workbook is active, when launching from PersonalBook, the one in the wb is run.

+ 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] Personal.XLSB macro pasting into Personal.XLSB
    By davepoth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2015, 07:40 PM
  2. Add procedure to PERSONAL.XLSB with a macro from another workbook.
    By dimattia in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-31-2013, 10:21 AM
  3. Run-Time Error 1004 When Running Macro from Another Personal Workbook (xlsb)
    By vcs1161 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-01-2013, 12:05 PM
  4. control of active workbooks when 2 open and code in personal.xlsb
    By alan_m20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-12-2012, 02:23 PM
  5. Personal.xlsb and procedure availability to spreadsheets
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2012, 05:30 PM
  6. Move or copy macro from Personal.xlsb to workbook
    By kazphilips in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-24-2012, 05:26 PM
  7. Personal.XLSB procedure to run in any project
    By jaimie1664 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2010, 11:34 AM

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