Solved: VBA Form Outside of Word

[petedw]

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

Many Thanks

Pete

[mdmackillop]

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

[Killian]

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

[petedw]

Thanks guys, i'll do that then.

Pete

[sheeeng]

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

I do agree that VBA without Office application cannot be run standalone.

The most you can do is set the following to true or false.

[VBA] Application.Visible = True [/VBA]

HTH

[MOS MASTER]

The most you can do is set the following to true or false.

[VBA] Application.Visible = True [/VBA]

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.

Invisible instances of Word could cause problems..

[sheeeng]

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.

Invisible instances of Word could cause problems..

Thx.

[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)