hi again,
sorry, click the button to soon
try something that save the specific sheet like
xls.SaveAs Filename:="C:\Book1.txt", _
FileFormat:=xlText, CreateBackup:=False
save the xls not the xlw.
>-----Original Message-----
>hi,
[quoted text clipped - 32 lines]
>>
>.
JeepNC - 31 Jan 2005 19:45 GMT
Thanks for the suggestion. I tried the sheet save and now get an error
SaveAs method of worksheet class failed.
> hi again,
> sorry, click the button to soon
[quoted text clipped - 40 lines]
> >>
> >.
anonymous@discussions.microsoft.com - 31 Jan 2005 20:50 GMT
hi again,
for what ever reason, it is failing because of the file
format. i took that out of the code and got it to save but
ended up with garbage in the text file. i tried saveing it
as a CSV file but it failed on that too. i think it's a
systax problem.
>-----Original Message-----
>Thanks for the suggestion. I tried the sheet save and now get an error
[quoted text clipped - 46 lines]
>>
>.