|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
January 29th 10, 03:42 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
Outlook custom form - VBS call VBA macro
I have created a custom OL form based on the Contact form. I want to save
data from some of the fields to a text file. I want to initiate the save using the WRITE event. I have written the SUB in VBA to save the data, but can't call the SUB from the form VBS. What is the solution or workaround? -- I ask, therefore I am. 
|
| Ads |
|
#2
January 29th 10, 04:20 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook custom form - VBS call VBA macro
If the Sub is a public Sub in the built-in ThisOutlookSession module, it
should be possible to call it as Application.MySub or whatever its name is. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "JMat45" wrote in message news  I have created a custom OL form based on the Contact form. I want to save data from some of the fields to a text file. I want to initiate the save using the WRITE event. I have written the SUB in VBA to save the data, but can't call the SUB from the form VBS. What is the solution or workaround? -- I ask, therefore I am.
|
|
#3
February 1st 10, 02:25 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook custom form - VBS call VBA macro
Ok, I will give that a try. Thanks for the advice.
-- I ask, therefore I am. "Sue Mosher [MVP]" wrote: If the Sub is a public Sub in the built-in ThisOutlookSession module, it should be possible to call it as Application.MySub or whatever its name is. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "JMat45" wrote in message news I have created a custom OL form based on the Contact form. I want to save data from some of the fields to a text file. I want to initiate the save using the WRITE event. I have written the SUB in VBA to save the data, but can't call the SUB from the form VBS. What is the solution or workaround? -- I ask, therefore I am. .
|
|
#4
February 1st 10, 03:22 AM
posted to microsoft.public.outlook.program_forms
|
|||
|
|||
|
Outlook custom form - VBS call VBA macro
Sue, worked great. I'm back in business. Thanks very much.
-- I ask, therefore I am. "JMat45" wrote: Ok, I will give that a try. Thanks for the advice. -- I ask, therefore I am. "Sue Mosher [MVP]" wrote: If the Sub is a public Sub in the built-in ThisOutlookSession module, it should be possible to call it as Application.MySub or whatever its name is. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "JMat45" wrote in message news I have created a custom OL form based on the Contact form. I want to save data from some of the fields to a text file. I want to initiate the save using the WRITE event. I have written the SUB in VBA to save the data, but can't call the SUB from the form VBS. What is the solution or workaround? -- I ask, therefore I am. .
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Custom VBA forms in Outlook--how to call w/macro? | Sharon Wright | Outlook - Using Forms | 1 | June 9th 09 06:46 PM |
| How to create and call Microsoft Custom Form in Outlook 2003 Mail? | Naval kishore | Outlook - Using Forms | 1 | May 8th 08 01:53 PM |
| Custom Form w/ DB Call | rm | Outlook - Using Forms | 0 | March 8th 07 01:35 AM |
| Call macro stored in Excel workbook from Outlook's macro | Gvaram | Outlook and VBA | 5 | October 4th 06 06:26 AM |
| How do I link a macro to a CommandButton in a custom form, want us | Capone2377 | Outlook - Using Forms | 1 | February 5th 06 12:15 AM |
Linear Mode
