MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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:= _
xlTextPrinter, CreateBackup:=True

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)

Posted by Mark W. on August 15, 2001 6:37 AM

Are you sure?

Tony are you *absolutely* sure that you're
opening the Formatted Text file that your VBA
code created? Is it possible that this statement
is not executed and some other Save As statement
in your code is? Is it possible that you're
saving to a different directory and; therefore,
you're opening another file with the same name?
I assure this statement works perfectly on my