How can I create an timesheet form using Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
I have been asked to explore the possibilities and I am just wondering if it
is possible.

Glynn
 
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
 
Back
Top