Create Path and Open Editable Doc in Word From a Report

[Charlie]

I am trying to run then export a report to Word so that it opens on a form
button click and is editable in word.

Using my limited knowledge I can create the report but then keep on getting
a msg box asking me where I want to save the file before I can view it. I
want to avoid this message box appearing and go straight into the doc.

Thank you very much in advance.

 

[Clifford Bass]

Hi Charlie,

How would Word find the report if it is not saved to a file somewhere?
To my knowledge, the export process requires the saving of a file. If you
personally do not want to be bothered by entering the file name and location,
you could specify a file in code to the export process and then when you
invoke Word, tell Word what that file's path and name are. If you need help
with this, post the code for your button's On Click event so I can see what
you are doing currently.

Clifford Bass