Hi,
I work in an engineering firm and have used excel in the past for various calc etc.
recently i put together a timesheet system for tracking and monitoring employee times on projects for billing etc. It was during this that i have come to realise the massive possibilities this program has.
This got me thinking about putting together a "document register" system using excel. It would be used in place of hard filing system. then registered documents could be easily searched etc.
this could assist in minimising space used to store hard copies also.
it could also take away responsibility in correctly naming electronic files.
The rough idea is as follows:
Users receive either electronic or hard copy documents
Open excel doc register, browse for the file they wish to register, enter relevant (searchable info) then click process, this renames the file to the correct format, and moves to the correct folder, also adds info to a master database with a hyperlink to the new file location. The in future other users can open the master, search based on fields, once document found they can click hyperlink which opens file.
I know this is fairly long winded, however has anyone created something similar, or come across something similar?
Cheers
I work in an engineering firm and have used excel in the past for various calc etc.
recently i put together a timesheet system for tracking and monitoring employee times on projects for billing etc. It was during this that i have come to realise the massive possibilities this program has.
This got me thinking about putting together a "document register" system using excel. It would be used in place of hard filing system. then registered documents could be easily searched etc.
this could assist in minimising space used to store hard copies also.
it could also take away responsibility in correctly naming electronic files.
The rough idea is as follows:
Users receive either electronic or hard copy documents
Open excel doc register, browse for the file they wish to register, enter relevant (searchable info) then click process, this renames the file to the correct format, and moves to the correct folder, also adds info to a master database with a hyperlink to the new file location. The in future other users can open the master, search based on fields, once document found they can click hyperlink which opens file.
I know this is fairly long winded, however has anyone created something similar, or come across something similar?
Cheers