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

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


    Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!


    Read this to understand why we ask you to do this

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


    You don't seem bothered nor had the courtesy to let us know that you have received an answer elsewhere.

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


    Sorry,
    it is the first time that I see messages about the crossposting issue.
    I thought that the forums were in free competition.
    Thank for the warning

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


    If can be useful, I had this aswer in The Code Cage forum:
    "You can only create dll files with VBA if you have a Developer edition of Office XP (or 2000, I think).
    Why do you want to do this? If it's for performance, unless you can use C++ I don't think you will benefit. "


    Regards

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


    The issue is the forums are free - and people give their time freely to help you. If you post on more than 1 board, then you are expected to at least let people know.


    Please read this - it explains why this is an emotive issue.

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


    it may be useful to you but it potentially wastes volunteers time, you even had the cheek to give bad rep ther to snb for reporting your cross posting! You haven't even bothered to thank Rory for his reply there.

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





    Dear royUK,
    There is too much emotion in your remarks. Calm down, itdoesn't seem the case.
    From you I expect open contributions (by the way, on the siteyou pointed out I did not find useful things to solve my problems).
    Thanks and regards.


    Lucio

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


    Quote

    ... From you I expect open contributions ...


    the help on this forum and the other forums is free, not to be taken for granted and "expected"


    did you read the link in paragraph 2 of Post #7?

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


    I haven't pointed out a site for you!!


    As you don't grasp the problems created by crossposting and are continuing with the other Forum, I'm closing this Thread

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login