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
