Legalese

QuickAccess is released under the Mozilla Public License (MPL). A copy of the license and the following notice are included in the QuickAccess distribution.

The contents of this file are subject to the Mozilla Public License Version 1.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.mozilla.org/MPL/

Software distributed under the License is distributed on an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License for the specific language governing rights and limitations under the License.

The Original Code is QuickAccess.

The Initial Developer of the Original Code is Habeeb J. Dihu aka MacGyver <macgyver@tos.net>. Portions created by Habeeb J. Dihu are Copyright © 1998 TOS Enterprises. All Rights Reserved.

Installation and Requirements

QuickAccess will work with any version of Quicken from 5.0 onward. It's been tested with Quicken 5.0, 6.0, '98, and '99. QuickAccess has been tested with Excel '97, but should work with at least Excel '95. Please let me know if you are able to get QuickAccess running on other configurations.
Please note: You must have Quicken running in order to use QuickAccess from Excel. If you don't, QuickAccess will give you a polite error message telling you that Quicken isn't running. This is not a limitation in QuickAccess, but rather of the Windows interfaces that Quicken uses in its undocumented interface.

Installing QuickAccess is relatively simple:

Download the quickaccess.zip file from http://www.macgyver.org/software/quickaccess/quickaccess.zip.
Unzip the quickaccess.zip file and run the setup.exe program. It should install all the necessary files and libraries on your system.
Please note: QuickAccess was developed using Microsoft Visual Studio '98. Since the latest and greatest system libraries ship with Visual Studio '98, you might see a message that says:
Setup cannot continue because some system files are out of date on your system. Click OK if you would like setup to update these files for you now. You will need to restart Windows before you can run setup again. Click cancel to exit setup without updating system files.
You need to be sure you choose the "OK" option and allow it to update your system libraries. After you restart your computer, run setup.exe again, and it ought to finish the install this time.
Open up Excel and go to the Tools menu and select the Add-Ins... option. When the Add-Ins menu comes up, select Browse... and then go to the directory where you chose to install QuickAccess (if you chose the defaults when you installed, it would be C:\Program Files\QuickAccess) and select the QuickAccess module. Make sure that QuickAccess is selected and then press OK.
And you're all done!

QuickAccess Excel Functions

Any parameters that appear between [] are optional and don't have to be given. If you want to use some optional fields, and not others, you can usually pass .., which is the Quicken wildcard matching string.

Any function that takes a Seperator argument uses the specified seperator to distinguish entries in a list. The default seperator is |. There are two special seperators: ROW and COL. These seperators tell QuickAccess to return an array (either as a row or as a column, respectively), so you can populate multiple cells at once. See the example workbook included with QuickAccess for some ways this can be used.

QuickenAcctList([Seperator])

This function returns a list of accounts that you have in Quicken.

QuickenBalance(Account, [EndDate], [StartDate], [Payee], [Category], [Class])

This function returns the balance of any Quicken account. If you don't specify any of the optional parameters, then it simply returns the current balance (which is probably what you want most of the time anyway). Otherwise, you can limit your balance search using any of the optional parameters.
The parameters are:

Account: This is the name of the account whose balance you want.
EndDate: Ending date that you want to include in your balance search.
StartDate: Start date that you want to include in your balance search.
Payee: Payee that you want to include in your balance search.
Category: Category that you want to include in your balance search.
Class: Class that you want to include in your balance search.

QuickenCatList([Type], [Seperator])

This function returns a list of Quicken categories, optionally seperated by [Seperator]. Valid paramters for [Type] are

All: This returns all categories. This is the default option, if none is specified.
Expense: This returns all expense related categories.
Income: This returns all income related categories.

QuickenSecShares(Security, [Date])

This function returns the number of shares you own of a security. If [Date] is specified, then the price of the security on that date will be returned. Otherwise, the most recent data is returned.
The parameters are:

Security: This is the security you want. You may either specify it by symbol or by name (as entered into Quicken).
Date: Date that you want the security's shares on.

QuickenSecPrice(Security, [Date])

This function returns the price of a security. If [Date] is specified, then the price of the security on that date will be returned. Otherwise, the most recent data is returned.
The parameters are:

Security: This is the security you want. You may either specify it by symbol or by name (as entered into Quicken).
Date: Date that you want the security's price on.

QuickenSecList([Seperator])

This function returns a list of security names that you have in Quicken.

QuickenSecSymbols([Seperator])

This function returns a list of security symbols that you have in Quicken.

QuickenSecOwned([Type], [Seperator])

This function returns a list of the securities you own (ie: have shares) in Quicken. Type, determines whether you get back a list of security names or security symbols. By default, QuickAccess will return a list of security symbols. If Type is names, then a list of security names is returned. If Type is unspecified, or set to symbols, then it returns a list of symbols.

QuickenSecName(Symbol)

Given Symbol, this function returns the full name of a security, as entered into Quicken.

QuickenSecSymbol(Name)

Given Name, as entered into Quicken, this function returns the symbol.