How to make an excel file as an exe applciation.

[satish12]

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

[MikeTheBike]

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_Op en event with the first line being
Application.Vis ible=False.

and the last line of code being

Application.Qui t

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!!

[satish12]

-----------------------------------------------------------------

[satish12]

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_Op en event with the first line being
Application.Vis ible=False.

and the last line of code being

Application.Qui t

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...