Relative location to open word document

[adamprocter]

I have an excel document that opens and pastes stuff into a word document
This code works like a dream

Set wdDoc = .Documents.Open("C:\Users\Adam\Desktop\Sample_template.docx")

But i would like to be able to move the excel file and word to a dropbox folder and use on any PC

so I tried

Set wdDoc = .Documents.Open("\sample_template.docx")

Looked in C:\
Any ideas ?

 

[adamprocter]

I want to move the excel sheet to dropbox and so the location is no the same on each machine but the files in that folder are.

I am still unable to do this

\dropbox\the_excelfile
\dropbox\the_wordfile

There must be a way to specify the relative location over absolute ?

 

[adamprocter]

I figured it out FYI
Set wdDoc = .Documents.Open(ThisWorkbook.Path & "\the_wordfile.docx")