Template wizard with data tracking

[Anson Ndoria]

I have developed forms in Excel 2002 to capture data at
schools level and save to an Excel workbook database using
TMPLWIZ.EXE wizard. We then use pivot tables and charts to
report on this data.

This tool has enabled us to leverage the only resources
readily available to schools - standalone computers loaded
with MS Office.

Now I find that newly supplied computers with Excel 2003
will not create the databases because TMPLWIZ.EXE is not
supported.

Is there an alternative to the wizard in Excel 2003?

 

[Ron de Bruin]

Hi Anson

There is no 2003 version on this moment

I hear that the 2002 Add-in is working correct in 2003
I never use it myself.

The problem is that the install file is not working in 2003.
You must copy the xla file from a 2002 machine to the machine
with 2003.

I can send you the xla if you can't do this