By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,057 Members | 1,346 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,057 IT Pros & Developers. It's quick & easy.

How to make an excel file as an exe applciation.

P: 5
HI,

Can any one tell me knon how to make an excel workbook as an exe application. As i have developed a code in VBA which open all the websites required. However, the user form is set show only when the work book is opened and the work book remains opened even after the webisites are opened. So i would like to know how to make it exe as we do in VB. So that i need not close or open the work book to run the application.

Thanks for any reponse
Dec 6 '07 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 635
HI,

Can any one tell me knon how to make an excel workbook as an exe application. As i have developed a code in VBA which open all the websites required. However, the user form is set show only when the work book is opened and the work book remains opened even after the webisites are opened. So i would like to know how to make it exe as we do in VB. So that i need not close or open the work book to run the application.

Thanks for any reponse
Hi

As fare as I am aware, this is not possible as VBA has to run in an application (hence the name!).

The only this I can suggest, using Excel, is

Run the code from the ThisWorkbook_Open event with the first line being
Application.Visible=False.

and the last line of code being

Application.Quit

The application will flash up briefly and disappear, but forms opened will be visible.

However, I don't know if there will be a need to delay closing the App to allow code to finish running.

HTH


MTB

ps Do put some error hander in to make the App visible if it errors, as you will not be able to see it otherwise!!
Dec 7 '07 #2

P: 5
-----------------------------------------------------------------
Dec 10 '07 #3

P: 5
Hi

As fare as I am aware, this is not possible as VBA has to run in an application (hence the name!).

The only this I can suggest, using Excel, is

Run the code from the ThisWorkbook_Open event with the first line being
Application.Visible=False.

and the last line of code being

Application.Quit

The application will flash up briefly and disappear, but forms opened will be visible.

However, I don't know if there will be a need to delay closing the App to allow code to finish running.

HTH


MTB

ps Do put some error hander in to make the App visible if it errors, as you will not be able to see it otherwise!!

Thank you very much for the valuable information...
Dec 10 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.