Run time error!

  • Thread starter Thread starter aiyer
  • Start date Start date
A

aiyer

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
 
Hi
try
ActiveSheet.SaveAs FileName:=filesaveName, FileFormat:=xlTextWindows

xlText is used for Pivottables and not for specifying a fileformat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Formatting! 3
File formatting! 2
Run Time Error on trying to save workbook 14
Run Time Error 1004 1
Error on ActiveWorkbook.SaveAs method 3
Excel Automation - Export Txt 4
Runtime error 1004 when trying to insert formula in cells 11
Getting a "Read-Only" error 2

Back
Top