Inquiry about Excel VBA integration with Quicken version 47

eloirjr Member
Dear All :) ,

I am writing to inquire about integrating Excel VBA with Quicken version 47. Specifically, I am trying to access a QDF file from Excel VBA and would like to know which DLLs need to be registered and which references need to be added to the VBA code.

Could you please provide me with the necessary information to accomplish this? I would greatly appreciate any guidance or resources you can provide.

Thank you for your time and assistance.



  • Greg_the_Geek
    Greg_the_Geek SuperUser, Windows Beta ✭✭✭✭✭

    I don't believe you can access a Quicken data file with Excel VBA. The data file format is proprietary and know only to Quicken.

    Quicken Subscription HBRP - Windows 10
  • Jim_Harman
    Jim_Harman SuperUser ✭✭✭✭✭

    Quicken does not have any provisions for its internal database to be accessed by other programs. You can, however, export any of its reports to Excel and manipulate the data there.

    If you can explain what you would like to accomplish, we may be able to point you in the right direction.

    QWin Premier subscription
  • eloirjr
    eloirjr Member
    I am trying import all accounts and transactions to a sheet on excel without export to .csv. Just trying be more fast the process, anyway thanks for your response. Have a nice day
This discussion has been closed.