ExcelBanter - Run time error!

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Run time error! (https://www.excelbanter.com/excel-programming/294213-run-time-error.html)

Hello all!

A quick question. I could save an active sheet in a workbook using th
following VBA command.

ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlText

It ran just fine in my computer where Excel 97 is installed. However
when I ran the same macro in another computer where Windows XP i
installed (I guess it is a different version of Excel loaded in it).
am getting a message that says quote " runtime error 1004
application-defined or object-defined error". I would appreciate yo
comments on this guys.
Thanks alot.

Arun Iyer
Vextec Corp

--
Message posted from http://www.ExcelForum.com

Hi
try
ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlTextWindows

xlText is used for Pivottables and not for specifying a fileformat

--
Regards
Frank Kabel
Frankfurt, Germany

"aiyer " schrieb im Newsbeitrag
...
Hello all!

A quick question. I could save an active sheet in a workbook using
the
following VBA command.

ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlText

It ran just fine in my computer where Excel 97 is installed. However,
when I ran the same macro in another computer where Windows XP is
installed (I guess it is a different version of Excel loaded in it).
I
am getting a message that says quote " runtime error 1004:
application-defined or object-defined error". I would appreciate you
comments on this guys.
Thanks alot.

Arun Iyer
Vextec Corp.

---
Message posted from http://www.ExcelForum.com/