Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Convert Quicken files to Excel

This is a discussion on Convert Quicken files to Excel within the Excel Questions forums, part of the Question Forums category; Exactly as in my post. A tag is just a word enclosed in brackets. In this case the word is ...

  1. #11
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,142

    Default Re: Convert Quicken files to Excel

    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
    Last edited by xenou; Nov 6th, 2011 at 10:27 AM.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  2. #12
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    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.

  3. #13
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,142

    Default Re: Convert Quicken files to Excel

    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,
    ξ

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  4. #14
    New Member
    Join Date
    Jan 2011
    Posts
    7

    Default Re: Convert Quicken files to Excel

    Step one: download this Welcome to the OFX Reader for Excel
    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.

    Note you can also copy the XLA file to your hard disk (Mac users) instead of running the installer.

    Instructions to load the Add-in
    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:

    To load the tool, first start Excel & make sure a workbook is open (one usually opens when you start Excel.)
    Excel 2007:
    1. Click the round Microsoft Office Button and then click Excel Options.
    2. Click Add-Ins and then in the Manage box select Excel Add-ins. Click Go.
    3. In the Add-Ins available box, click Browse... & browse to the folder to which you installed this tool (see below.)
    4. Select the *.xla file & Press OK to close the dialogs.

    Excel 2000 - 2003:
    1. Launch Excel and then choose Tools | Add-ins... from Excel's menu.
    2. Click Browse... & browse to the folder to which you installed this tool.
    3. Select the *.xla file & Press OK to close the dialogs.

    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.
    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.


    Important Other Instructions
    The OFX Reader is designed to help you importer OFX files into Excel.

    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.

    Look for *.OFX, *.QFX, or *.QBO files, which can all be read.

    Thank You,
    The Big Red Consulting Team




    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.


    Tghia is the best I can do from memory.

Page 2 of 2 FirstFirst 12

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com