Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Excel to Quicken 2009
Does anyone know of a program or macro that will convert an Excel 2007
spreadsheet into a format (QFX?) that can be imported into Quicken 2009? Thanks in advance -- John |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert Excel to Quicken 2009
I wrote a custom macro for somebody earlier this year. But it is different
for for each quicken file. Quicken will import CSV data and you can save CSV from excel using File - SAVEAS and selecting CSV. You can then build your Quicken database. If you are going to do this a lot then I recommend developing a custom macro. What I did the last time was to work backwards. Build your quicken database. The export the quicken Database to CSV format. You should be able to import that same CSV file back into quicken. The reason for exporting the quicken data is to get the proper format of the quicken database. Then you can write a custom macro in excel VBA to export the excel database to match you quicken database.. "John" wrote: Does anyone know of a program or macro that will convert an Excel 2007 spreadsheet into a format (QFX?) that can be imported into Quicken 2009? Thanks in advance -- John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can subtact or add Week 07/2009 in one column & Week 10/2009 . | Excel Worksheet Functions | |||
How create 365 labels for 2009? Example: Monday, Jan. 4, 2009 | Excel Discussion (Misc queries) | |||
Importing Excel into Quicken | Excel Discussion (Misc queries) | |||
Can Excel do things lilke Quicken | Excel Discussion (Misc queries) | |||
Can Excel do things like Quicken | Excel Discussion (Misc queries) |