calling a VBA form from an Outlook form 
Author Message
 calling a VBA form from an Outlook form

Does anybody know what VBScript to write to get a VBA form to display by
clicking a custom button on an outlook form?

Thank you!

*** Sent via Developersdex http://www.*-*-*.com/ ***
Don't just participate in USENET...get rewarded for it!



Sun, 15 May 2005 05:55:03 GMT  
 calling a VBA form from an Outlook form
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.
--
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:

> Does anybody know what VBScript to write to get a VBA form to display by
> clicking a custom button on an outlook form?

> Thank you!

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Fri, 20 May 2005 06:37:44 GMT  
 calling a VBA form from an Outlook form
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.
--
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:

> Does anybody know what VBScript to write to get a VBA form to display
by
> clicking a custom button on an outlook form?

> Thank you!

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


Fri, 20 May 2005 23:26:08 GMT  
 calling a VBA form from an Outlook form
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?



Sat, 21 May 2005 00:15:04 GMT  
 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!


Sat, 21 May 2005 00:40:17 GMT  
 
 [ 5 post ] 

 Relevant Pages 

1. need to call a VBA user form from an outlook custom form

2. run Outlook form from Exchange library with VBA code

3. How to export Outlook VBA modules and Form from another application

4. Resizable VBA forms (dialogs) in Outlook.

5. How to export Outlook VBA modules and Form from another application

6. Using VBA from Outlook form

7. Outlook VBS Form's and VBA

8. outlook forms script editor - execute VBA editor modules

9. Sending a outlook form with vba

10. Start VBA userform from an Outlook form with VB script

11. run Outlook form from Exchange library with VBA code

12. How to set the form I design default in Outlook 2000 by program(VBA)

 

 
Powered by phpBB® Forum Software