Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Compiling VBA to .exe file (creating own library)

  1. #1
    Join Date
    24th February 2006
    Posts
    5

    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.

    VB:
    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 
    
    
    VB:
    Sub addins() 
    End Sub 
    
    
    VB:
    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 at 19:24.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039

    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

    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.

  3. #3
    Join Date
    26th January 2003
    Location
    UK
    Posts
    4,684

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

    Opened by jiuk (U2u received)

    jiuk

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    26th January 2003
    Location
    Derbyshire,UK
    Posts
    18,039

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

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

    Roy

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Library File Name
    By senarumugam2003 in forum EXCEL HELP
    Replies: 3
    Last Post: March 22nd, 2007, 15:08
  2. Compiling File
    By Alvinkiang in forum EXCEL HELP
    Replies: 9
    Last Post: June 22nd, 2006, 17:11
  3. compiling spreadsheets
    By Lawrence1979 in forum EXCEL HELP
    Replies: 5
    Last Post: November 26th, 2005, 07:14
  4. compiling VBA
    By chand in forum EXCEL HELP
    Replies: 4
    Last Post: October 14th, 2005, 10:16

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
  •  
porno