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

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

Cheers
Nigel

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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

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

<(E-Mail Removed)> a écrit dans le message de
news:(E-Mail Removed)...
> 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

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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 =---