creating an exe file with visual basic (installation file for Macros and Userforms)

G

Guest

Hello,

is it possible to create an exe file (something like an
installation file) with visual basic.
Right now I'm using an userform to run my macros and
I don't want to include this userform every time I'm
creating a new Excel-file.
How can I create an installation file that automatically
creates this userform in an Excel-file??
I hope someone can help me!
Thanks a lot!
Mibi
 
P

papou

Hello Mibi
You can't make an exe file from VBA.
But there are tools which will allow deployment of vba applications, these
tools ara available with the Office developper toolkit.

HTH
Cordially
Pascal
 
K

Keith Willshaw

Hello,

is it possible to create an exe file (something like an
installation file) with visual basic.
Right now I'm using an userform to run my macros and
I don't want to include this userform every time I'm
creating a new Excel-file.
How can I create an installation file that automatically
creates this userform in an Excel-file??
I hope someone can help me!
Thanks a lot!
Mibi
Click to expand...

Uing VB6 Professional , VB.net or Office Developer edition
you can build a dll thats loaded in to your excel workbook
and does this.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dno2kta/html/comaddins.asp

Keith
 
Top