I have created a form using VB within Microsoft Word. I would like to run this form outside of Word as if it were an application.
Can anyone tell me how this can be done?? : pray2:
Many Thanks
Pete
Printable View
I have created a form using VB within Microsoft Word. I would like to run this form outside of Word as if it were an application.
Can anyone tell me how this can be done?? : pray2:
Many Thanks
Pete
Hi Pete,
I don't believe you can do this. You would need a standalone application such as VB6. The closest you could get would be to hide the word application on startup eg http://www.vbaexpress.com/kb/getarticle.php?kb_id=184
Regards
MD
What you want to do is compile your form & code as a stand-alone executable.
This is not possible with VBA - you will need to recreate it in a suitable application environment like Visual Basic (classic or dotNet).
Thanks guys, i'll do that then.
Pete :thumb
I do agree that VBA without Office application cannot be run standalone.Quote:
Originally Posted by Killian
The most you can do is set the following to true or false.
[VBA] Application.Visible = True [/VBA]
HTH :friends:
This would work but you have to make very sure to include a good error handler to take care of the application object when a unexpected error occurs.Quote:
Originally Posted by sheeeng
Invisible instances of Word could cause problems..:whistle:
Thx.:friends:Quote:
Originally Posted by MOS MASTER
No Problem you where right that in that way you could make it look like a true program with just the form on top. (Although we know better) :*)