Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 02-14-2022, 03:51 PM
Guessed's Avatar
Guessed Guessed is offline Transfer DocVariables from one template's userform to another template's userform Windows 10 Transfer DocVariables from one template's userform to another template's userform Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

This version doesn't error if the variable already exists and if the variable doesn't exist it creates it.
Code:
Private Sub VariableTransmission()
  Dim doc1 As Document, doc2 As Document, aVar As Word.Variable
  
  Set doc1 = ActiveDocument
  Set doc2 = Documents.Add
  
  doc1.Variables("First").Value = "Hi mum"    'resets value or creates if it doesn't already exist
  doc1.Variables("Second") = "Hello world"
  doc1.Variables("Second") = "Hello world"
  
  For Each aVar In doc1.Variables
    doc2.Variables(aVar.Name) = aVar.Value
  Next aVar

  Debug.Print doc2.Variables("Second").Value
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm with Combo Box from data in table within template jhansrod Word VBA 6 06-13-2019 09:02 AM
Excel Userform to Word Template Bookmarks JCrinage Excel Programming 1 11-02-2016 07:03 PM
Transfer DocVariables from one template's userform to another template's userform Agenda template - userform kennyD Word 4 04-07-2015 01:32 PM
userform to enter multiple lines of data in template callasabra Word VBA 0 06-27-2014 05:29 PM
How to get Outlook 2007 userform into template? Royzer Outlook 0 04-13-2012 10:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 PM.


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