How to save/export my formatted report from Access-DB to Word-File?

[Baloo]

hi, all!

It's a simple question. I'm sorry, but I couldn'd find an answer in this forum

I have formatted several nice reports.
Could you be so kind to help me in VBA to save/export for example my Report1 from DB1.mdb to Report.DOC (I need to save format of pages too: fonts, colors, footers, etc...).

Code/example would be very much appreciated

thanks in advance!
kind regards.
Baloo.

[RobDog888]

In Access, Tools > Office Links > Publish It with Microsoft Office Word.

[Baloo]

hi RobDog,

thanks a lot, but I need to do it in Access VBA programmatically.
could you be so kind to show me VBA-code?

kind regards,
Baloo.

[RobDog888]

You can use Application.DoCmd.RunCommand acCmdOutputToRTF after your report is opened.

[Baloo]

hi,

RobDog888, thanks a lot once more! but I have three more questions

I've used:

DoCmd.OutputTo acReport,"repMyReport", acFormatRTF, "C:\MyDoc.doc", False

and it works, but in this case: Word can't save all formats of my report fields /colors of fields from Detail-region/ That's why I have to use - acCmdOutputToRTF

also about -

Application.DoCmd.RunCommand acCmdOutputToRTF

1) how to save my Report in the definite path, for example "C:\MyReport.DOC"? Unfortunately I can't use reference to MS-Word, because my each user have different Word-version
2) and can I do it in general without opening Word-application?
3) it displays the Database Window which I want to keep hidden from the users?

Any help or hints would be most appreciated

kind regards,
Baloo.

[RobDog888]

You can use Late Binding to accomodate multiple versions of Word.

When using RunCommand acCmdOutputToRTF you can not specify a directory path via code.

So basically you want to output a Word report without Access being visible and how about Word?