thanasiscy
07-20-2015, 04:36 AM
Dear all,
I face some issues with the encoding when i try to capture some text using VBA (either this is filename or a Cell text).
i need to capture the text within VBA and then send it to an existing Batch Script or a Text File.
In case of the text file my batch script cannot read the created text file.
In case of the script. My variables are shown correct when the batch script is UTF-8, but when i change it to ANSI then they get scrambled and the script itself do not read them correct.
Is there any good quide on this? I am using VBA 7.1
I want to reading different text from Cells or filenames and be able to have the text as ANSI and send it as ANSI so then i can effectively read it in my batch scripts without loosing or messing the characters.
Thanks in advance for your help.
Best Regards,
Athanasios
I face some issues with the encoding when i try to capture some text using VBA (either this is filename or a Cell text).
i need to capture the text within VBA and then send it to an existing Batch Script or a Text File.
In case of the text file my batch script cannot read the created text file.
In case of the script. My variables are shown correct when the batch script is UTF-8, but when i change it to ANSI then they get scrambled and the script itself do not read them correct.
Is there any good quide on this? I am using VBA 7.1
I want to reading different text from Cells or filenames and be able to have the text as ANSI and send it as ANSI so then i can effectively read it in my batch scripts without loosing or messing the characters.
Thanks in advance for your help.
Best Regards,
Athanasios