+ Reply to Thread
Results 1 to 1 of 1

Ideas/Recommendations for a project using custom plugins (Highly complex)

  1. #1
    Valued Forum Contributor
    Join Date
    08-29-2012
    Location
    In lockdown
    MS-Off Ver
    Excel 2010 (2003 to 2016 but 2010 for choice)
    Posts
    1,766

    Ideas/Recommendations for a project using custom plugins (Highly complex)

    I am working on a system that has a main workbook and a number of custom "plugins".

    The idea is that the end user opens the main workbook. This offers a choice of plugins. Whichever plugin is chosen customises the main workbook interface for the end user.

    Whichever interface button is selected by the end user is redirected to the active plugin and runs the code in there. (Note that the procedure in the plugin may contain calls to procedures in the main workbook).

    Currently the main workbook is a XLSM (I am thinking of changing this to a XLAM in the near future) and the custom plugins are merely XLSM workbooks. (Would change to XLAMs if this made it any easier)

    The main workbook calls code in the plugins as follows
    1. The current plugin workbook is opened (in the background)
    2. The main workbook calls an Application.Run
    3. At the start of the first procedure in the plugin, the plugin workbook loads a reference to the Main Workbooks project
    4. The plugin runs whatever procedure was called
    5. The main workbook closes the plugin after the Application.Run completes
    6. The plugin has an event trigger on workbook close to unload the reference to the main workbook

    I'm looking for ideas on how to improve the calls between the two workbooks. Or any alternative concepts similar to what I am trying to do.

    Should I make the plugins XLAM? (but I don't want them installed or appearing in the Add-Ins library)

    I occasionally run into issues with the Application.Run (sometimes you cant debug). Instead of adding the main workbook as a reference to the plugin, should I add the plugin as a reference to the main workbook? (Which would do away with the need for Application.Run) This would mean that all plugins would have to have the same project name, correct?
    Last edited by mc84excel; 03-03-2015 at 06:59 PM.
    *******************************************************

    HELP WANTED! (Links to Forum threads)
    Trying to create reusable code for Custom Events at Workbook (not Application) level

    *******************************************************

+ 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. Highly Complex Conditional Formula Help Needed
    By Aimeeeshaw in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-03-2013, 12:13 PM
  2. Ideas for a transparent/better display of complex table
    By MoneyPenny in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-05-2013, 03:25 PM
  3. Complex Product Selection Tool. Any ideas?
    By zappabeef in forum Excel General
    Replies: 12
    Last Post: 08-21-2012, 10:53 AM
  4. Complex conditional summing formula...ideas?
    By acovato in forum Excel General
    Replies: 7
    Last Post: 12-09-2009, 03:04 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