Trying to export data from Excel to Word (using Office 365)
When I search I get millions of hits on converting excel to word..... Can't seem to find what I'm looking for.
This will be used on different computers with different users etc... so has to have a generic path to the file. With MS Access I'd use currentproject.path like the second example below.
When I use these I get the following errors.
Set doc = wd.Documents.Open(Application.CurrentProject.Path & "\TestINPORT.docx")
Run time Error 438 Object doesn't support this property or method
Set doc = wd.Documents.Open(CurrentProject.Path & "\TestINPORT.docx")
Compile error. Variable not defined
When I search I get millions of hits on converting excel to word..... Can't seem to find what I'm looking for.
This will be used on different computers with different users etc... so has to have a generic path to the file. With MS Access I'd use currentproject.path like the second example below.
When I use these I get the following errors.
Set doc = wd.Documents.Open(Application.CurrentProject.Path & "\TestINPORT.docx")
Run time Error 438 Object doesn't support this property or method
Set doc = wd.Documents.Open(CurrentProject.Path & "\TestINPORT.docx")
Compile error. Variable not defined