Results 1 to 6 of 6

Thread: Transform a VBA module in a compiled Add-In for Excel

  1. #1
    Junior Member
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0

    Transform a VBA module in a compiled Add-In for Excel

    Good morning.
    For a technical application I'm using Excel 2013 as a user interface, to show inputs and results with tables and charts.
    In this VBA project, calculations are made in a large module that contains only subroutines for number-crunching.
    In these subroutines the inputs and outputs are Public variables and there is no reference to Excel objects.
    I would like to turn this VBA module in a compiled Add-In, running under the Main program written again in VBA.

    Question: what is the easiest way to create this compiled add-in and how to do it?

    I don't know C++, but I read somewhere that you can create compiled add-ins for Excel also using VBA.
    I would be grateful if you could advise me some papers which explain the best procedure in VB or VBA, in a simple and comprehensive way, with examples step by step.

    Any suggestion will be welcome.
    Thanks and regards.
    Lucio

  2. #2

  3. #3
    Moderator
    Join Date
    Jul 2012
    Posts
    156
    Rep Power
    13
    Dear Lucio,

    Please read following message regarding crossposting.

    http://www.excelfox.com/forum/f25/me...1172/#post5326

  4. #4
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Hope you've read and understood the http://www.excelfox.com/forum/f25/message-to-cross-posters-1172/

    To save code as an add-in, just look up topics in a search engine and get results like Create Your Own Excel Add-In | PCMag.com
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  5. #5
    Junior Member
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0
    Sorry,
    it is the first time that I see messages about the crossposting issue.
    I thought that the forums were in free competition.
    Thanks for the warning

  6. #6
    Junior Member
    Join Date
    Jan 2013
    Posts
    5
    Rep Power
    0
    Regarding your answer, it is understood that a XLAM is not the solution.

    I want to turn a VBA module of math., with no reference to Excel objects, in a compiled Add-in, quick, safe and simpler to deploy.

    • Keeping in mind that I don't want to automate Excel objects, but only subroutines for numeric calculations, I would like to know if it is preferable a COM, a DLL or something else.

    • I would like to know also if it is really necessary to compile with VB (as for example I read that you can create COM files in a simpler way, with VBA).

    I hope that it is clearer now.
    Finally, I would be grateful if you could also advise me documents on what you feel is the best procedure for my target.

    Thanks and regards.

Similar Threads

  1. Excel VBA Code to Add New Sheets
    By cdurfey in forum Excel Help
    Replies: 1
    Last Post: 06-25-2013, 08:05 AM
  2. Manipulate VBA Array Object Using Class Module
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 0
    Last Post: 06-06-2013, 07:53 PM
  3. Add VBA Reference From Another Application Excel To PowerPoint
    By ds1001 in forum Rajan Verma's Corner
    Replies: 1
    Last Post: 06-02-2013, 02:43 PM
  4. Array Class Module
    By Rajan_Verma in forum Rajan Verma's Corner
    Replies: 3
    Last Post: 12-20-2012, 11:22 AM
  5. Add ribbon programmatically to Excel 2010 using VBA
    By heapifyman in forum Excel Ribbon and Add-Ins
    Replies: 6
    Last Post: 07-18-2011, 09:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •