0

I need to convert some txt files to ANSI encoding. These files should have ANSI encoding according to Notepad++ encoding description.

I compare these files to a sample file which is identified by Notepad++ as ANSI encoded. These files should have ANSI encoding to be able to upload them to an old application.

I need to do it automatically as a part of VBA code which I also use to create the files from Excel data. Each time the macro pastes data from Excel to new workbook and saves as text file. Maybe it is possible to just choose encoding while saving Excel file but I didn't find the ANSI encoding in save options in Excel.

Thomas Dickey
  • 51,086
  • 7
  • 70
  • 105
bhuiokmnb7891
  • 3
  • 1
  • 5
  • 1
    Possible duplicate of [VB6/VBScript change file encoding to ansi](https://stackoverflow.com/questions/5182102/vb6-vbscript-change-file-encoding-to-ansi) – cyboashu Jun 01 '18 at 14:17

1 Answers1

0

I figured out that maybe the best way would be to open each text file in Notepad and save as choosing the ANSI encoding. Is it possible to do using Shell call in VBA ?

bhuiokmnb7891
  • 3
  • 1
  • 5