MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel 98 for macintosh

Posted by tony on August 14, 2001 11:13 AM

i am writing a spreadsheet for both the pc and the macintosh.

the following code works fine on the pc in my vba routine.

ActiveWorkbook.SaveAs FileName:=UniqueFile2, FileFormat:= _
xlTextPrinter, CreateBackup:=True

on the mac, it saves a file in excel format
on the pc, it saves a file in text format(which is what i want)..

any ideas why it doesnt work on mac, and is there another way to do this??


Posted by Mark W. on August 14, 2001 12:10 PM

> on the mac, it saves a file in excel format

Are you sure? That's not the case on my Mac!
Clearly, it creates a Formatted Text (Space
delimited) file with a Creater Type of "XCEL"
and File Type of "TEXT". What makes you think
that it's not a text file? Is it because a
double-click will open it using Excel. If you
don't believe me compare what happens when you
open a small binary (.xls) file in SimpleText
(or preferably, BBEdit) and the one created with
your VBA code. See the difference.

Posted by Aladin Akyurek on August 14, 2001 12:15 PM

Did you switch to OS X? I still didn't take the step (in part because of VPC)?

Posted by Mark W. on August 14, 2001 12:22 PM

Nope. Although it will become more enticing with
the release of Office 10...

Posted by tony on August 15, 2001 5:06 AM

maybe i have mispoken. let me clarify. I need to be able to open the file in something like notepad. I open the one from the pc and it displays fine. I open the one form the mac and everything is on 1 long line with a bunch of unprintable characters mixed in with the text.
i assumed it was in excel format still..
anyway, i want just plain text that i can send to other people on a pc.