PC Review


Reply
Thread Tools Rate Thread

How do I update a template wizard form to Excel 2007?

 
 
Dave McAllister
Guest
Posts: n/a
 
      12th Jun 2008
Greetings

I just upgraded to Office 2007. I recently created a data entry template
using the Template Wizard in Excel 2002. This entered a new row of data to a
database workbook whenever I saved the template. I have tried using the old
form, and saving it as a macro-enabled .xlsm file, but neither has the same
functionality as the old template. All I get is an error that 'the Template
Wizard cannot be opened'. I haven't been able to find anything online that
addresses this. Does anyone know how to fix the template so it regains the
old functionality? Failing that, is there a simple way to create data entry
forms in Excel 2007 to add new lines to a db workbook? The default Excel
data forms won't work in my application, as I need to include combo boxes and
populate some cells with default data based upon the user's selections from
the combo boxes.

Your assistance is greatly appreciated.

Dave
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i use template wizard with data tracking in excel 2007 Paul Microsoft Excel Misc 1 8th Jul 2008 09:56 PM
How do I update Template Wizard-created templates to Excel 2007? Dave McAllister Microsoft Excel Misc 0 13th Jun 2008 09:50 PM
Template Wizard Excel 2007 =?Utf-8?B?Z3BsYW50?= Microsoft Excel Misc 0 9th Aug 2007 07:30 PM
How do I use the Template Wizard in Excel 2007? =?Utf-8?B?Z3BsYW50?= Microsoft Excel Misc 0 8th Aug 2007 10:44 PM
Template Wizard in Excel 2007 roch@rochlalande.com Microsoft Excel Worksheet Functions 0 24th Mar 2007 01:09 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:44 PM.