This changes the file to Unicode but only after it is closed but this code doesn't close the file so I think my only remaining issue is how to close the text file after it is converted.
Sub...
Type: Posts; User: norm42; Keyword(s):
This changes the file to Unicode but only after it is closed but this code doesn't close the file so I think my only remaining issue is how to close the text file after it is converted.
Sub...
I tried this script but didn't change the file:
Sub TestTXTFileOpen()
Dim fileToOpen, system, file, contents, newFile
fileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")...
Just to clarify, when I say "open a text file" I'm not referring to importing into the spreadsheet. I want to open the file and change the encoding before the import step.
I have a VBA program that opens a text file but needs to do a SaveAs and change the encoding to Unicode. I haven't been able to figure it out.