Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 923
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 52
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default 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 =---
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to connect visual basic with excel file ? taha Excel Discussion (Misc queries) 2 October 26th 05 03:25 PM
How to Open A File with Visual Basic Lance[_3_] Excel Programming 1 November 18th 03 08:43 PM
Excel-Microsoft Visual Basic File Not Found Donna McMahan Excel Programming 1 October 31st 03 05:02 PM
Converting text to pdf file using Visual Basic nitin khabia Excel Programming 1 September 12th 03 02:10 AM
Visual Basic Programming Difficulties with linking Userforms Chuckie Excel Programming 2 August 7th 03 09:08 PM


All times are GMT +1. The time now is 09:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"