How can I create an timesheet form using Excel

[Glynn Barnard]

I would like to create a timesheet in Excel and post it in our Public Folders
for employees to complete each. I would also like to design it so it is sent
to a manager for approval after completion.

 

[Sue Mosher [MVP-Outlook]]

Outlook version?

 

[Glynn Barnard]

Exchange Server 2003 Office 2003

 

[Sue Mosher [MVP-Outlook]]

Is there a particular reason for using a public folder rather than a shared
network folder and an Excel template?

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers

 

[Glynn Barnard]

I have been asked to explore the possibilities and I am just wondering if it
is possible.

Glynn

 

[Sue Mosher [MVP-Outlook]]

It's awkward. Opening the template from a PF doesn't create a new document
based on the template. Instead, it opens the template for editing.

Another option would be to use an Office document form, but you can't create
that directly in Office 2003. You have to use a template created in Office
2000 and then modify the spreadsheet to suit you. Copy/paste is OK.
Templates are available at http://www.outlookcode.com/files/ODforms.zip

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers