Save as .txt

  • Thread starter Thread starter Jo HAN
  • Start date Start date
J

Jo HAN

Hi,

I have this code that works well:

Application.DisplayAlerts = False
With wb
.SaveAs "e:\data\sales\" & sh.Name & ".xls"

How ever when I change it to save as a text field is does not save it. I
waits for the save button before saving.

This is the line that I tried:

..SaveAs "e:\data\sales\" & sh.Name & ".txt", FileFormat _
:=xlUnicodeText, CreateBackup:=False

Can some one please help?

Tx
 
Back
Top