Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm generating a flat file in Outlook VBA. Right now I'm able to save it as a
..txt file, although I hope to save it in a delimited flat file format with an ..xls extension so it will automatically be opened by excel without having to go through the whole 'import' sequence. There are string fields in the file, some of which contain commas- so I can't make it a comma delimited file. What is the best delimiter to use so that Excel will automatically recognize and parse the flat file contents across columns? Currently in 2003, but strongly prefer solutions that will also work in 2007 Many thanks, Keith |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to load web page into Excel properly? | Excel Discussion (Misc queries) | |||
YYY-MM-DD format is changing when convert data to Flat File | Excel Programming | |||
convert matrix to flat file format | Excel Discussion (Misc queries) | |||
Repeated data into flat file format | Excel Worksheet Functions | |||
How to convert a Pivot Table into a Flat File format? | Excel Discussion (Misc queries) |