Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What process is performed behind excel? | Excel Discussion (Misc queries) | |||
Opening an Excel file in a DIFFERENT process clicking on its SHORT | Excel Discussion (Misc queries) | |||
'The process cannot access the file because it is in use by anothe | Excel Discussion (Misc queries) | |||
Lost Excel file changes in Outlook attachment due to save process | Setting up and Configuration of Excel | |||
How do I make a process map in Excel? | Charts and Charting in Excel |