Assigning existing document to variable in vba

Question

I want to assign an existing document to a variable which I can open and activate later. There might be several documents open when running the code (including the document containing the VBA project) so I need make sure I'm activating the right one.

The below doesn't work because I need the filename and not the file-path in the final line, but I don't know how to extract this from the path in line 2...

Dim NewQuote1 as string
Set NewQuote1 ="C:\Library\doc1.docx"
Documents.Open fileName:=NewQuote1
...
Documents(NewQuote1).Activate

You can use filesystemobject to get the filename property you're looking for. Couple good examples showing how to use it at blogs.technet.microsoft.com/heyscriptingguy/2006/05/30/… — dbmitch
– dbmitch, Commented Nov 15, 2016 at 17:07

Darren Bartrup-Cook · Accepted Answer · 2016-11-15 17:32:07Z

4

I'm not up on my Word VBA, but I'm pretty sure it'll be very similar to Excel.

So:

Sub Test()

    Dim wrdDoc As Document
    Dim NewQuote1 As String

    NewQuote1 = "C:\Library\doc1.docx"

    Set wrdDoc = Documents.Open(NewQuote1)

    'You can now reference the document using wrdDoc.
    wrdDoc.Activate

    MsgBox wrdDoc.Name

End Sub

answered Nov 15, 2016 at 17:32

Darren Bartrup-Cook

20.2k2 gold badges27 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Paddy.M Over a year ago

that's very helpful. Thanks

Darren Bartrup-Cook Over a year ago

Just noticed in your question that you talk about the document containing the VBA project - this document can always be referenced using ThisDocument, so ThisDocument.Activate, Msgbox ThisDocument.Name, etc.

Collectives™ on Stack Overflow

Assigning existing document to variable in vba

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related