Convert Quicken files to Excel

Patric · Nov 4, 2011

Hello friends:

How would I convert Quicken files to Excel?

My bank provides information in .qfx files. I do not own a Quicken program and I cannot locate a conversion tool.

There must be thousands of people with the same dilemma...can someone please give me some advice and direction?

Thanks in advance.

xenou · Nov 6, 2011

Exactly as in my post. A tag is just a word enclosed in brackets. In this case the word is NOPARSE. The closing tag has a forward slash after the first bracket and before the word.

This page gives examples of BB tags and their usage in this forum:
http://www.mrexcel.com/forum/misc.php?do=bbcode

Patric · Nov 7, 2011

Well, with your direction and a lot of trial and error, I got the BRC OFX Reader to work.

I needed to install a VBA add-in to Excel to make the reader operable.

Thank you for all your effort and direction.

xenou · Nov 7, 2011

Graet. If you get a chance to say what add-in you needed I think I've seen this question before so it may be useful to someone else if you have an opportunity to exactly describe the solution.

Regards,
ξ

Patric · Nov 8, 2011

Step one: download this

[FONT=&quot]Welcome to the OFX Reader for Excel[/FONT]
[FONT=&quot]If you've just run the tool's installer and haven't yet loaded the add-in, you're not quite finished. Please follow the steps below to load the add-in.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Note you can also copy the XLA file to your hard disk (Mac users) instead of running the installer.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Instructions to load the Add-in[/FONT]
[FONT=&quot]When Installation is complete, you may load this tool from within Excel. This is a one-time process. Once loaded, each time Excel starts the tool will be available until you unload it:[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]To load the tool, first start Excel & make sure a workbook is open (one usually opens when you start Excel.)[/FONT]
[FONT=&quot]Excel 2007:[/FONT]
[FONT=&quot]1. Click the round Microsoft Office Button and then click Excel Options.[/FONT]
[FONT=&quot]2. Click Add-Ins and then in the Manage box select Excel Add-ins. Click Go.[/FONT]
[FONT=&quot]3. In the Add-Ins available box, click Browse... & browse to the folder to which you installed this tool (see below.)[/FONT]
[FONT=&quot]4. Select the *.xla file & Press OK to close the dialogs. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Excel 2000 - 2003:[/FONT]
[FONT=&quot]1. Launch Excel and then choose Tools | Add-ins... from Excel's menu.[/FONT]
[FONT=&quot]2. Click Browse... & browse to the folder to which you installed this tool.[/FONT]
[FONT=&quot]3. Select the *.xla file & Press OK to close the dialogs. [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]At this point, you should see this tool listed in the Add-In dialog, with a checkmark next to it. Press OK to close the dialog, which will load the Add-In. [/FONT]
[FONT=&quot]In Excel 2007, you’ll see the tool’s access points from the Add-Ins tab. In Excel 97 – 2003 you’ll see a new menu item appear just to the right of Excel’s help menu.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Important Other Instructions[/FONT]
[FONT=&quot]The OFX Reader is designed to help you importer OFX files into Excel.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]To use the Add-in, first download an OFX file from your bank, credit card Company, or investment account provider. They will often refer to these files as meant to integrate with Quicken, QuickBooks, MS Money, or other financial application. Now they’ll also work with Excel.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Look for *.OFX, *.QFX, or *.QBO files, which can all be read.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thank You,[/FONT]
[FONT=&quot]The Big Red Consulting Team[/FONT]

[FONT=&quot][/FONT]

[FONT=&quot][/FONT]
[FONT=&quot]Next, put in your MS Office disc in and click repair . In this myriad of options, one of them VBA? adds the ability to make the QFX Reader operable.[/FONT]

[FONT=&quot][/FONT]
[FONT=&quot]Tghia is the best I can do from memory.
[/FONT]

Convert Quicken files to Excel

Patric

New Member

xenou

MrExcel MVP

Excel Facts

Patric

New Member

xenou

MrExcel MVP

Patric

New Member

Similar threads

Forum statistics

Share this page

Convert Quicken files to Excel

Patric

New Member

xenou

MrExcel MVP

Excel Facts

Patric

New Member

xenou

MrExcel MVP

Patric

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock