Export Access report to Excel using extended characterset

[Twan Kennis]

My Access report contains some characters from an extended characterset
(In Office subset: "Miscellaneous Dingbats" from "Notmal text")
These are WHITE CIRCLE and BLACK CIRCLE.
All characters are formatted with Arial.

When I export my Access report to Excel using the export-function from
the menu,
the output is perfect, and all extended characters are displayed
correctly.

But when I export my Access report using VBA using the follwing command:

DoCmd.OutputTo(acReport, objReport.Name, acFormatXLS, strOutputFile)

The output looks the same, but all extended characters are displayed as
a "?".
I already tried the Encoding-parameter (UTF8, Western, Auto Detect, ...)
in the command above,
but without any succes so far.

Does somebody know the solution to solve this problem?
Thanx in advance.

 

[Twan Kennis]

Obviously acFormatXLS as a formatting-value corresponds with the
"Micrososft Excel5-7"
export-format when executing "DoCmd.OutputTo"

Question is: How can I force Microsoft Access to use the "Micrososft
Excel97-2002" format
when running DoCmd.OutputTo.

Greetings, Twan Kennis
SKB Vragenlijst Services, The Netherlands