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

[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

 

[Nigel]

Why not create a template file and use this to create a new file ?

Cheers
Nigel

 

[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

 

[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

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