How to create an *.exe file with VBA

[luzelenamartelo]

Hello fellows of Mr. Excel.

I would like to know if it is possible to create an executable file with Visual Basic 6.0 for an excel appplication. I have developed aa application with the VBA in excel, but i want to create a file that i could install in any computer and if it´s possible, using Visual Basic 6.0 because i would like to open the file directly and not by opening an excel file.

Thanks a lot for any assistance.

Luz E. Martelo

 

[NdNoviceHlp]

In VB6, select Add-Ins, Add in manager, VB6 Resource editor, Loaded/Unloaded, OK, select VB resource editor on tool bar (green), click Add Custom resource (on tool bar of the Resource editor) and add your .xls file. Note the "CUSTOM" number added. Use the following code to instal the .xls file. (not my code. My apolgies for not including the unknown author). HTH. Dave

LoadDataIntoFile 120, "C:\Myfilename.xls"
' ***120 is Custom Resource number
' "C:\Myfilename.xls" is file destination

Public Sub LoadDataIntoFile(DataName As Integer, filename As String)
    Dim myArray() As Byte
    Dim myFile As Long
    If Dir(filename) = "" Then
        myArray = LoadResData(DataName, "CUSTOM")
        myFile = FreeFile
        Open filename For Binary Access Write As #myFile
        '
        Put #myFile, , myArray
        
        Close #myFile
    End If
End Sub