How to open files from dropbox share

Hi there

I have a macro which opens .doc .docx and .txt files.... I've tested this on my local drive using the activesheet path to find the files. The file I want to open are in a folder called 'September' off of where the activesheet is. This is all working well locally.

However I actually need this to run from a dropbox file share, when I run it from there it just opens word but can't open the first file.... Any ideas how I can get this to run from a dropbox file share? At first I thought it might be because the file has spaces in it but I copied this file locally and it run fine locally from my D drive etc.

Here is part of my macro

On Error GoTo errorHandler
 Dim wdApp As Word.Application
 Dim myDoc As Word.Document
 Dim mywdRange As Word.Range
 Dim Date1 As Excel.Range
 Dim Date2 As Excel.Range
 Dim sPath As String
 sPath = ActiveWorkbook.Path

Set wdApp = New Word.Application
 With wdApp
 .Visible = True
 .WindowState = wdWindowStateMaximize
 End With
 
Set newdate1 = Sheets("Data").Range("B4")

 
Set myDoc = wdApp.Documents.Open _
(Filename:=sPath & "\September\Teacher SEPTEMBER pay meeting survey .docx", ReadOnly:=False)

Many thanks in advance.

Marie