Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-09-2014, 03:05 AM
BoringDavid BoringDavid is offline Is it possible to take an input from a UserForm in one document to a UserForm in a do Windows XP Is it possible to take an input from a UserForm in one document to a UserForm in a do Office 2010 32bit
Novice
Is it possible to take an input from a UserForm in one document to a UserForm in a do
 
Join Date: Sep 2013
Posts: 19
BoringDavid is on a distinguished road
Default Is it possible to take an input from a UserForm in one document to a UserForm in a do

All our letter templates open with a UserForm that the user populates; one of the inputs dictates if the letter is going overseas, which adjusts information within the template such as our telephone number (it adds +44 to the beginning of the number). One particular template then adds a “process document” using this code:



Code:
 
Documents.Add Template:="File Path\process document.dot", NewTemplate:=False
The “process document” provides details of what we are going to do and currently does not change; however, it does include several telephone numbers. I have now been asked to update the document so that the telephone numbers are amended dependent on where the letter is being sent

When this opens a UserForm appears and the user chooses one of two CommandButtons which will then amend the telephone numbers.

My question is, is it possible for the first document to launch the “process document” and then either select the appropriate CommandButton or to negate this stage altogether and update the “process document” without a UserForm?
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is it possible to take an input from a UserForm in one document to a UserForm in a do Checkbox in Userform lukael Excel Programming 5 02-18-2014 05:20 AM
Userform Code not quite right - help please vbanovice Word VBA 1 09-29-2013 09:20 PM
Is it possible to take an input from a UserForm in one document to a UserForm in a do Show userform without losing document focus? Or other method to get a graphic to pop? AlexR Word VBA 7 03-31-2013 12:17 PM
Is it possible to take an input from a UserForm in one document to a UserForm in a do How to link userform to another word document SaneMan Word VBA 5 10-14-2011 05:12 AM
Is it possible to take an input from a UserForm in one document to a UserForm in a do Setting focus to specific word document from UserForm SaneMan Word VBA 5 04-01-2011 03:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft