excel 98 for macintosh
Posted by tony on August 15, 2001 5:13 AM
*** posted this originally on 8/14/01, but was not clear on my problem, so reposted **
i am writing a spreadsheet to create a text file for both the pc and the macintosh.
the following code works fine on the pc in my vba routine.
ActiveWorkbook.SaveAs FileName:=UniqueFile2, FileFormat:= _
on the mac, 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 from the mac and everything is on 1 long line with a bunch of unprintable characters mixed in with the text.
anyway, i want just plain text that i can send to other people on a pc.
on the pc, it saves a file in text format(which i can open with notepad)