MrExcel Publishing
Your One Stop for Excel Tips & Solutions

file created in excel macintosh, sent to pc.

Posted by tony on August 16, 2001 10:43 AM

I am creating a file out of excel 98 on a MAC using VBA. the fileformat is xltextprinter.
When i send it over to the pc, it all ends up being 1 line record.
I know on macs that it only uses a carriage control to end a line, unlike a pc, which uses both a carriage control and a line feed to end a line.
My question is: how can i get the correct format for the pc??

Posted by Mark W. on August 16, 2001 10:57 AM

Take your fine to a system editor and replace all
occurances of < cr > with < cr > < newline >.

Using BBEdit that would be \r to \r\n