DJI Computer Solutions

Software Applications for Microsoft Excel

Individual Product Support

Checkbook for Excel

Handicap Manager for Excel

Golf Tracker for Excel

Project Manager for Excel

Tax Assistant for Excel

Golf Tracker for Excel Support Page

Frequently Asked Questions - Table of Contents

1. I get a run-time error 6 or run-time error 1004 when clicking the Enter Score or Save score buttons on my scorecards.
2. When I try to edit a scorecard or enter a score, the new workbook task pane opens but nothing else happens. How can I access my scorecards or enter a new score?
3. When I start Golf Tracker for Excel, I receive a message stating that "The macros in this project are disabled." How do I correct this problem and enable macros?
4. I get an application error and sometimes Excel crashes when I'm using Golf Tracker. How do I correct this problem?
5. I get a VBA error when I click the "Save Score" button after entering scoring information into a score card. The program then stops without transferring the score or saving the scorecard. How do I correct this problem?
6. How do I transfer data from a previous version of Golf Tracker for Excel to the new version?

I get a run-time error 6, run-time error 13 or run-time error 1004 when clicking the Enter Score or Save score buttons on my scorecards.

These problems occurred on some Excel installations with version 1.2 & 1.3. To correct the problem, make sure you have the latest version of Golf Tracker for Excel - version 1.3a or later. If this does not solve the problem, you will need to download and install the latest service pack for your version of Microsoft Office. (There was a bug in the initial release of Excel 2002 (XP) that caused the error on some installations but it may also apply to earlier releases also.) You will need to recreate your scorecards if you are still getting run-time 6 errors after installing the latest updates.

Back to Top

When I try to edit a scorecard or enter a score, the new file task pane opens but nothing else happens. How can I access my scorecards or enter a new score?

If you are using Excel 2002 (XP), the "New Workbook Task Pane" is displayed when you click the "Enter Score" button. Just select the General Template option and the New File dialog box will appear. Select the Golf Courses tab and all of your golf course scorecard file templates will be listed. This behavior only affects the initial release of Excel 2002 (XP) and can be corrected by installing Service Pack 1 for Microsoft Office. In Excel 97 and 2000, the New File dialog box is displayed by default.

Back to Top

When I start Golf Tracker for Excel, I receive a message stating that "The macros in this project are disabled." How do I correct this problem and enable macros?

In order to enjoy all the features that our Excel applications provide, it is necessary to have macros enabled in Excel. You may receive a security warning that the file "contains macros by DJI Computer Solutions." In order for Golf Tracker for Excel to do its job, you will need to enable the macros it contains. Rest assured that the macros are safe and perform only basic Excel functions. They have been digitally signed and protected to insure that they were created by DJI Computer Solutions. To enable the macros and eliminate future warning for files published by DJI Computer Solutions, check the "Always trust macros from this publisher" check box and click the Enable Macros button. If you are still having problems enabling macros or would like additional information, click this link to our Security page.

Back to Top

I get an application error and sometimes Excel crashes when I'm using Golf Tracker. How do I correct this problem.

This problem is caused by a bug in Office/Excel 97 and you can correct the problem by downloading the latest patches for Office 97. The bug is due to a program installing a newer version of the Office Automation files (including OLEAUT32.DLL) that is not completely compatible with Excel 97. You can determine which Excel patches you need to apply by reading the Microsoft Knowledgebase article Q232652 at: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232652

If you are experiencing frequent crashes in Excel 2000 or Excel 2002/XP, use the Detect and Repair option on the Help menu to verify that your Excel installation has not been damaged and the Office automation features are still intact. You can also go to the Microsoft Office web site and use the Office Update feature to install the latest patches. When installing the latest patches, Excel's macro security policy will be modified without your permission. Click this link to our Virus Protection page for more details.

This problem also occurred with some Windows 98/NT  installations and the error was due to the opening screen graphic embedded in the Golf Tracker for Excel main sheet. This problem is corrected with  version 1.1b and higher. You can download the most recent version from the Golf Tracker Home Page. To see instructions for importing your data from a previous version to the new version, click this link.

Back to Top

I get a VBA error when I click the "Save Score" button after entering scoring information into a score card. The program then stops without transferring the score or saving the scorecard. How do I correct this problem?

This problem occurred on some Excel 97 and Excel 2000 installations and the error message varied depending on the version of Golf Tracker for Excel. This problem is corrected with  version 1.1b and higher. You can download the most recent version from the Golf Tracker Home Page. To see instructions for importing your data from a previous version to the new version, click this link.

Back to Top

How do I transfer data from a previous version of Golf Tracker for Excel to the new version?

You can simply cut and paste the data into the new version. All the scorecard templates and the scorecards that you have created will continue to work as they are.

•  To copy your data to the new version, open both versions of the Golf Tracker for Excel workbooks. The only data that you need to copy is in the "Data" sheet and the "Golfers" sheet. Starting with the data sheet, select all the data starting with cell A3 and extending down and to the right to include all of your data plus one additional column. It is critical that you include at least one blank column to the right of your data when you copy it. There are hidden columns that store statistical information that will not be copied if you do not include the blank column. Your selection should extend at least through column BS.
• After selecting all the data, select Edit-Copy from the Excel menu (or click the Copy tool).
• Switch to the "Data" sheet in the new version and select cell A3. Then select Edit-Paste from the Excel menu (or click the Paste tool).
• Now repeat the process with the "Golfers" sheet, selecting all the data starting with cell A4 and extending down and to the right to include all the golfer data. Then copy and paste it into the same location (cell A4) of the "Golfers" sheet in the new version.
• Once you have copied all the data from the "Data" and "Golfers" sheets, the process is complete. You can then close the old version and save the new version.
• Use the Golf Tracker for Excel function buttons to recreate any reports or charts.

Back to Top

Copyright © 2000-2012  DJI Computer Solutions. All rights reserved.
Revised: December 29, 2011 .