Save as .txt

[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

 

[BrianB]

I see 2 dots before SaveAs instead of 1