T
Theo van der Ster
I'd love some help with the following:
For later reference, I often write sentences from a Word file to a text file with the following macro:
Open strFile For Append As #1
Print #1, "string to be saved"
Close #1
I then use another macro to retrieve said sentences and show them in a dialog box. This works fine, except when strings contain foreign characters, such as ë or ó. On a Windows PC the characters show as they should, but on another platform, e.g. Mac, the characters come out garbled.
I suppose this is because my file gets saved as DOS text. I also suppose a unicode file would translate correctly across platforms. The question is, how do I make sure my file gets saved in unicode? Or is there another solution I haven't thought of?
TIA and best regards,
Theo van der Ster
The Netherlands
(e-mail address removed)
For later reference, I often write sentences from a Word file to a text file with the following macro:
Open strFile For Append As #1
Print #1, "string to be saved"
Close #1
I then use another macro to retrieve said sentences and show them in a dialog box. This works fine, except when strings contain foreign characters, such as ë or ó. On a Windows PC the characters show as they should, but on another platform, e.g. Mac, the characters come out garbled.
I suppose this is because my file gets saved as DOS text. I also suppose a unicode file would translate correctly across platforms. The question is, how do I make sure my file gets saved in unicode? Or is there another solution I haven't thought of?
TIA and best regards,
Theo van der Ster
The Netherlands
(e-mail address removed)