Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as space delimited file from VBA
Hi,
I'd like to save my file from VBA, but as a space delimited file, i.e.with a single space between cell values. Does any of xlFileFormat values produce this result? I really don't feel like testing each one... TIA, Nash |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as space delimited file from VBA
Hi
I don't think that you can do it but there are a couple of options that I can think of to solve it: 1. As as a CVS and then convert all commas to spaces (although this may cause problems with other commas in the file. 2. save as a .prn formated text file and then delete mutliple spaces. Have a think about or see what others come up with. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Nash" wrote: Hi, I'd like to save my file from VBA, but as a space delimited file, i.e.with a single space between cell values. Does any of xlFileFormat values produce this result? I really don't feel like testing each one... TIA, Nash |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I save a 40meg 26,000 row file to Space Delimited format | Excel Discussion (Misc queries) | |||
Lost columns in formated text (space delimited) save | Excel Worksheet Functions | |||
Output space-delimited file with quotes around text? | Excel Discussion (Misc queries) | |||
Parsing a space delimited file into segments | Excel Discussion (Misc queries) | |||
HOW DO I EDIT AN EXISTING FILE TO BE SPACE DELIMITED? | Excel Discussion (Misc queries) |