m m
Technical Support
m
OfficeQ Sample Application - Microsoft Excel (file: QXCL_CODEC.XLS)
Jul 15, 2013: We are currently rewriting our entire web site. This page may be useful - but is not yet complete and may contain misleading or incomplete information or inoperative links. Please check back soon for the final version. Email support@datablox.com if you have questions.

This sample application can extract all the accounting data from a QuickBooks file and insert it into an MDB database file. Queries can then be run against the data that output information into Excel spreadsheets. Many examples are provided and you can easily add your own.

Purpose

The main purpose of this application is to provide a working application to extract data from QuickBooks, save that data, run queries on that saved data, and create spreadsheets using the resulting query data.

It also provides a good working application base using Excel that could be modified for many other uses. Many of the issues that would be common to other applications are solved in this application - with full source code provided.

Software Prerequisites

This application requires the following to run:

Major Functionality Provided

This application provides user interface components and Excel VBA source code to do the following:

Installation

A Windows 'install' file is provided ...freedownload vs licensed / part of most officeq downloads...

Copyright / Modifications / Redistribution Allowed

This application can be copied or modified as desired. The full programming source code is provided. That programming code is open source and can be used for any purpose.