Discussion Locked

File creation time stamp for Excel

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a class of over 150 students who download Excel templates and then complete the template as their weekly assignment. Because all 150 students have the same assignment there is a a lot of copying.

I would like to create a VBA or some otherlanguage if easier, program that after downloading the generic template the first time this template is opened by the individual student, it will automatically place the system date and time in the File Creation Properties box.

This macro would only run when the file is first opened. The second time the file is opened the orginal date and time stamp would not be affected.

I could then use some software I have (File grabber from PC magazine) to sort all the assignments by file creation date. If I find two assignments with the exact creation date then the spreadsheet is copied.

I am very comfortable in Excel but am having problems with the code to accomplish this.

Can anyone help? Any help would be very appreciated.

Thanks...Bernie

7 replies

by dklippert

Take a look at:
http://www.cpearson.com/excel/docprop.htm
There is a discussion of Document properties.
The Create date will reflect the date that a document is created using a template (File>New). That date stays the same even if resaved.
However there are a number of ways to over write this, for instance.
Sub CreateDate()
ThisWorkbook.BuiltinDocumentProperties("Created").Value=Now
End Sub
Will change the date. You might want to create a cusom date, or have an Auto_Open macro that writes to a hidden worksheet. All that being said. If a beginning student can defeat the Created date, they should move up to the next level.

by lo

I haven't totally tried this, but ...

You should be able to do a VBA macro that on opening would force the create date. It could also hide the sheet with the VBA macro and password protect those parts you don't want accessed.

On first run, the create (or a create date) would be set, macro disabled, hidden, etc.

There is probably a way for a knowledgable person to defeat that also (you can encrypt the pw, and such but ...).

I agree with previous, if you have a student that can defeat that, they are probably beyond your class already.

by estebandelatorre

As long as I can read, the main problem is find a student who had copied it's work from another student...
Date & time functions may not be enought in order to see if they are copied, but why don't you sort all the .xls files by size?

Student PC's should be:
.Without drive a: or with a lock password
.No workgoup available between them
.Only one share foder with all right per student
.Only one READ only share folder per class
.No email available

This discussion is closed to new replies.