Search:

Type: Posts; User: norm42; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    12,575

    This changes the file to Unicode but only after...

    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...
  2. Replies
    3
    Views
    12,575

    I tried this script but didn't change the file: ...

    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")...
  3. Replies
    3
    Views
    12,575

    Just to clarify, when I say "open a text file"...

    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.
  4. Replies
    3
    Views
    12,575

    Text file SaveAs from Excel VBA

    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.
Results 1 to 4 of 4