Word VBA: Open and work with a different doc from userform?

gmayor · #1 06-25-2018, 05:23 AM

Your process is a bit vague but presumably you will get the office (here a string strOffice) from the userform, so something along the lines of:

Code:

Dim oDoc As Document
Dim strOffice As String

    Select Case strOffice
        Case "London"
            Set oDoc = Documents.Add("c:\path\London templatename.dotm")
        Case "New York"
            Set oDoc = Documents.Add("c:\path\NY templatename.dotm")
            'etc
    End Select
    'do stuff with oDoc

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Open Userform once and apply the same selection to multiple documents	Formd	Word VBA	2	12-12-2017 10:11 AM
Problem with add-ins that don't work that I can't delete b/c Excel, Word, etc won't open	bcs	Office	3	02-25-2016 03:37 PM
Powerpoint Userform sharing across all open presentations	James Kreiner	PowerPoint	2	09-24-2014 09:52 AM
Workaround to have UserForm open from Web Link	Kirsti	Word VBA	11	08-23-2012 07:05 PM
Text created in Work 2010- will not open in Word 2007	Ole Sarge	Word	1	05-27-2011 03:06 PM