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
