Bookmark and Share

Enter your email address:

Delivered by FeedBurner

Home Page

Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!

eXTReMe Tracker

  Friday, August 29, 2008 – Permalink –

Template Wizard with Data Tracking

Add it back in

Add-ins are often replaced in new versions of Office. In Office 2000, Excel had a Wizard that would create an entry form and store information in a database.

To retrieve that function you need to add back the Template Wizard.

"The Microsoft Excel 2002 Template Wizard is an add-in program that sets up a database to store data entered from an Excel form. When you load the add-in program, the Template Wizard command is added to the Data menu in Excel."

When you download the WZTEMPLT.XLA, you must install it in the Office11 folder:
X:\Program Files\Microsoft Office\Office11\Library

How to install the Excel 2002 Report Manager add-in and Template Wizard add-in in Excel 2003 and 2007

The Wizard can be downloaded here:
Excel 2002 Add-in: Template Wizard with Data Tracking

(When you run the executable, be sure to change the destination to the Office11 folder, if you are using Office 2003, Office 12 for 2007.)

How to use the Template Wizard with the Data Tracking add-in
Also see:
Report Manager

[Edited entry from 5/16/2005]

See all Topics


<Doug Klippert@ 3:33 AM

Comments: Post a Comment

Links to this post:

Create a Link