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

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

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

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

Cheers
Nigel

wrote in message
om...
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

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

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

a écrit dans le message de
om...
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

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

wrote in message
om...
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/de.../comaddins.asp

Keith




----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeed.com The #1 Newsgroup Service in the World! 100,000 Newsgroups
---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =---