I'm trying to use excel to do some processing on a QIF file (using
VBA). I've made some good progress but I have hit one problem that I
don't understand. I'm posting in this group because I can reproduce
the problem doing just very simple manual operations in excel. Here is
the scenario:
- open the QIF file using file open, select all files *.*
- use the text import wizard, set options so that 1 line in QIIF file
is entered into 1 cell (all data in column A)
- change any text date (this is fundamentally a text file) from
10/13/2009 to 10/12/2009 (just to require the save dialog box to open)
and save the file back to the original file
- Now re-open the file using a word processor and there will be cells
other than the one noted above that have changed. In particular, a
cell that was orignally in this form:
T-17.56
will now be enclosed in quotes like this:
"T-17.56"
It appears that the save operation is causing this cell content
change, as the contents look good before saving. And only some of the
cells are changed, it is always a cell similar to the one noted above,
that is, it is a row that always starts with "T", but not all the rows
like this are modified.
Can anyone explain what is causing this behavior and more importantly
how I can avoid it?
TIA
John Keith
