
calling a VBA form from an Outlook form
Thank you Sue! You continue to be a miracle worker in programming
Outlook!
Re: calling a VBA form from an Outlook form
From: Sue Mosher [MVP]
Running Application.MySub from an Outlook form's VBScript code will run
the code that you provide in the MySub subroutine. The statement to load
a VBA form is MyForm.Show, not .Display, so the procedure could be:
Sub MySub
MyForm.Show
End Sub
Obviously, you'd test the procedure from VBA first before ever trying to
get it to work from VBScript. And remember, this is unsupported. Your
mileage may vary.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers
http://www.slipstick.com/books/jumpstart.htm
Quote:
> Sue i actually tried that and it didn't work. Does MySub have to have
> the form somehow embedded in it or can it just call the form via
> myform.display?
> Thank very much!
> Re: calling a VBA form from an Outlook form
> From: Sue Mosher [MVP]
> There is no supported method for doing this. The unsupported method is
> to create a subroutine (MySub) in the ThisOutlookSession module that
> shows your form. You can then call it from the form's VBScript with
> Application.MySub.
> > Does anybody know what VBScript to write to get a VBA form to
display
> by
> > clicking a custom button on an outlook form?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!