View Single Post
  #1  
Old November 14th, 2009, 08:15 AM posted to microsoft.public.excel.misc
John Keith
external usenet poster
 
Posts: 27
Default Using excel to process QIF file

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