Excel Template Wizard - any good?

MIMF · Apr 5th, 2002, 09:13 AM

Has anyone used the Excel Template Wizard that automatically adds records to a database file?
Do combo boxes and the information stored in them work as part of this process?

lenze · Apr 5th, 2002, 09:32 AM

Where I work, we have used the Template Wizard for many useful applications. We have a template used by everyone in our department(30+ people)to record activities charged to overhead and transmit this to a database for our boss to review and write his reports from. We have used it to take surveys from employees state wide (500+) and tabulate data. We have also used it with ourmanagers to tabulate performance ratings for employees to a central database for HR to utilize. It can be a very handy tool when you need to collect information from many users or when you are inputing the same data over and over. Of course, each user must have access to the drive where the database file is stored.

MIMF · Apr 5th, 2002, 09:49 AM

Our users are all connected on a MS Exchange network. Presumably the database file could be stored so that all users could submit entries using the Excel Template Wizard?

lenze · Apr 5th, 2002, 09:52 AM

I'm not sure how MS Exchange works. Basically, you need a shared drive where an Excel File can be stored that all users have access to open and edit.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 09:13 AM	#1
MIMF New Member Join Date: Apr 2002 Posts: 16	Has anyone used the Excel Template Wizard that automatically adds records to a database file? Do combo boxes and the information stored in them work as part of this process?

Apr 5th, 2002, 09:32 AM	#2
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	Where I work, we have used the Template Wizard for many useful applications. We have a template used by everyone in our department(30+ people)to record activities charged to overhead and transmit this to a database for our boss to review and write his reports from. We have used it to take surveys from employees state wide (500+) and tabulate data. We have also used it with ourmanagers to tabulate performance ratings for employees to a central database for HR to utilize. It can be a very handy tool when you need to collect information from many users or when you are inputing the same data over and over. Of course, each user must have access to the drive where the database file is stored.

Apr 5th, 2002, 09:49 AM	#3
MIMF New Member Join Date: Apr 2002 Posts: 16	Our users are all connected on a MS Exchange network. Presumably the database file could be stored so that all users could submit entries using the Excel Template Wizard?

Apr 5th, 2002, 09:52 AM	#4
lenze MrExcel MVP Join Date: Feb 2002 Location: Helena, MT Posts: 13,690	I'm not sure how MS Exchange works. Basically, you need a shared drive where an Excel File can be stored that all users have access to open and edit.