Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David D.
 
Posts: n/a
Default Importing Quicken QFX files into Excel

Is there a way to import a Quicken QFX file into Excel? An add-in perhaps?
Or maybe someone has already written a macro?

- David



  #2   Report Post  
Rowan Drummond
 
Posts: n/a
Default

Export the data from quicken as a csv file which you can then import
directly into excel. I don't have quicken on this machine but If I
remember correctly the csv format is under the print report options.

Hope this helps
Rowan

David D. wrote:
Is there a way to import a Quicken QFX file into Excel? An add-in perhaps?
Or maybe someone has already written a macro?

- David



  #3   Report Post  
David D.
 
Posts: n/a
Default

Rowan,

Thanks for the reply. Unfortunately I do not have Quicken.

Some financial institutions give you the option to download account data
as either "Quicken" or "Money", but not as .CSV. That is why I wanted to
be able to import .QFX directly into Excel.

- David


"Rowan Drummond" wrote in message
...
Export the data from quicken as a csv file which you can then import
directly into excel. I don't have quicken on this machine but If I
remember correctly the csv format is under the print report options.

Hope this helps
Rowan

David D. wrote:
Is there a way to import a Quicken QFX file into Excel? An add-in

perhaps?
Or maybe someone has already written a macro?

- David





  #4   Report Post  
David D.
 
Posts: n/a
Default

Rowan,

Thanks for the reply. Unfortunately I do not have Quicken.

Some financial institutions give you the option to download account data
as either "Quicken" or "Money", but not as .CSV. That is why I wanted to
be able to import .QFX directly into Excel.

- David


"Rowan Drummond" wrote in message
...
Export the data from quicken as a csv file which you can then import
directly into excel. I don't have quicken on this machine but If I
remember correctly the csv format is under the print report options.

Hope this helps
Rowan

David D. wrote:
Is there a way to import a Quicken QFX file into Excel? An add-in

perhaps?
Or maybe someone has already written a macro?

- David





  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

If you see that data you want on the screen, you can always (from your browser
window) copy it an paste into an Excel sheet. It may need some "cleaning up",
however.

On Fri, 30 Sep 2005 11:05:10 -0400, "David D."
wrote:

Rowan,

Thanks for the reply. Unfortunately I do not have Quicken.

Some financial institutions give you the option to download account data
as either "Quicken" or "Money", but not as .CSV. That is why I wanted to
be able to import .QFX directly into Excel.

- David


"Rowan Drummond" wrote in message
...
Export the data from quicken as a csv file which you can then import
directly into excel. I don't have quicken on this machine but If I
remember correctly the csv format is under the print report options.

Hope this helps
Rowan

David D. wrote:
Is there a way to import a Quicken QFX file into Excel? An add-in

perhaps?
Or maybe someone has already written a macro?

- David






  #6   Report Post  
David D.
 
Posts: n/a
Default

"Myrna Larson" wrote in message
...
If you see that data you want on the screen, you can always (from your

browser
window) copy it an paste into an Excel sheet. It may need some "cleaning

up",
however.


Thanks for the suggestion. That is what I usually do. Unfortunately, I
need to page through a half dozen separate pages to get all of the account
data, a little from each page. That is why I wanted to use the download
facility instead.

But copying the data one page at a time will be quicker than my writing and
debugging a macro to do it for me.

I wonder why a financial institution would go to the trouble to provide
complex Quicken and Money data files, but not a simple .CSV file for a
spreadsheet.

- David



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
Importing multiple Text files into Excel 2003 JMA Excel Discussion (Misc queries) 5 May 5th 05 09:48 PM
Open excel files jfa3012 Excel Discussion (Misc queries) 0 April 21st 05 02:52 PM
Importing txt csv files into Excel greater than 65k lines strippier Excel Discussion (Misc queries) 1 April 20th 05 06:34 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 02:39 AM


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"