Hi
I have this code to open up a file which works when it's an excel doc;
But doesn't work when it's a word doc (run-time error 1004) with this code;
I'm unsure why? Any help would be appreciated.
I have this code to open up a file which works when it's an excel doc;
Code:
Workbooks.Open Filename:="[URL="file://\\servertest\Test Administration\Dep"]\\servertest\Test Administration\Dep[/URL]artment Name\Dashboards\Test 1\Book1.xlsx"
But doesn't work when it's a word doc (run-time error 1004) with this code;
Code:
Workbooks.Open Filename:="[URL="file://\\servertest\Test Administration\Department Name"]\\servertest\Test Administration\Department Name[/URL]\Dashboards\Test 1\Test.docx"
I'm unsure why? Any help would be appreciated.