xlTextPrinter and Accounting format
I suspect there may be conflict with the comma delimiter as in comma
seperated values
I don't understand what you mean by 'conflict'. If you save a PRN file than
it is not a CSV file. The formats are different. Are you renaming the file
to CSV? That doesn't make it one.
--
Jim
wrote in message
...
| I'm using the xlTextPrinter file format to save fixed width text
| files, but I have run into a problem with "Accounting" formatted
| cells.
|
| When saved in xlTextPrinter format, the numbers in accounting formats
| have all of the digits after the first comma deleted. I suspect there
| may be conflict with the comma delimiter as in comma seperated values,
| but I'm not completely sure.
|
| Anyone have any experience with this? The code works perfectly in all
| other cases.
|