Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel Template Wizard - any good?

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    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?

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  4. #4
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •