If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|