Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Compiling VBA to .exe file (creating own library)

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Compiling VBA to .exe file (creating own library)

    I seen a VBA code in .xla format. Now it should be installed first creating own folder and then extract and refer to .dll file to run it.
    Can I do that too in all excel programs tools I made? It should be look like installer first where it will extract the .xla (add-in file)first and refer to .dll before it run)

    Here is the sample codes in .xla referring to .dll file in order to work.


    Declare Function Dimensioner Lib "C:\Program Files\cleardim\dimensioner.DLL" ( _
    ByVal Block As Double, ByVal Voice As Double, ByVal Video As Double, _
    ByVal Videoce As Double, ByVal Csdata As Double, ByVal Csdatace As Double, _
    ByVal Csdatarate As Double, ByVal Pstghput1 As Double, ByVal Psdata1 As Double, _
    ByVal Psdatace1 As Double, ByVal Psdatarate1 As Double, ByVal Pstghput2 As Double, _
    ByVal Psdata2 As Double, ByVal Psdatace2 As Double, ByVal Psdatarate2 As Double, _
    ByVal Psthput3 As Double, ByVal Psdata3 As Double, ByVal Psdatace3 As Double, _
    ByVal Psdatarate3 As Double) As Double

    Sub addins()
    End Sub

    Sub DImensionerMacro()

    End Sub

    How can i do this also. Like prepare .dll file tie-up with my .xls program or .xla.
    Hope somebody can help me to do it too. Can it be done in Visual Basic?
    What's the steps?

    I want to do this to patent the tools I made for me.

    Thanks a lot!
    Last edited by Jack in the UK; April 7th, 2006, 19:24.

  • #2
    Re: Compiling VBA to .exe file (creating own library)

    David - Please read THIS PAGE IN FULL.

    I have corrected several of your earlier posts & PM'd you about Code Tags. You continue to ignore this, so I am locking this post until you do as requested - ie read & understand the Rules.
    Hope that Helps

    Roy

    New users should read the Forum Rules before posting

    For free Excel tools & articles visit my web site

    If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

    RoyUK's Web Site

    royUK's Database Form

    Where to paste code from the Forum

    About me.

    Comment


    • #3
      Re: Compiling VBA to .exe file (creating own library)

      Opened by jiuk (U2u received)

      jiuk

      Comment


      • #4
        Re: Compiling VBA to .exe file (creating own library)

        Thanks jack, really busy at the moment will call you later
        Hope that Helps

        Roy

        New users should read the Forum Rules before posting

        For free Excel tools & articles visit my web site

        If I have helped you and you feel like putting your hand in your pocket please make a donation to Children in Need

        RoyUK's Web Site

        royUK's Database Form

        Where to paste code from the Forum

        About me.

        Comment

        Trending

        Collapse

        There are no results that meet this criteria.

        Working...
        X