'Save as' to export a report to word needed

  • Thread starter Thread starter davion123
  • Start date Start date
D

davion123

Hello all,

I have a report that I can easily enough export through a macro to a
word document to a specific location. That works fine.

It is alos easy enough to create the wizard export report button which
then gives the user the choice of format and desired location of where
to save the report. (Word is not an option here)

Question:

Is there a way to combine the functionality of these two items so that
the user can export a report to word with the 'save as' option to put
it in a desired location?

Thank you,

David M.
'Data Analyst'
 
Maybe. What if you used the OpenSaveFile API from Access web, grabbed
the name and the path etc of the output file and then wrote it there.
IIRC, you should be able to assign the result of the API's return value
to a string variable and go from there.
 
Back
Top