How can I write a VBA macro in Excel, or use some other automated programming tool to pick up the original client-side file creation date and author on the client machine? I want to substitute that date in the document library when a file is uploaded. I have that information listed in an Excel spreadsheet already, with a full path to the file included on the same row, so excel would be the easiest method.
As it is right now, when users drag and drop files using Explorer View or any other standard method, the file creation date of the original file is replaced by the current date. I don't want to require manual input for the correct dates, or the users will never move the masses of files that we are talking about, only to lose this data. I want this tool to be available through Excel or some other method that does not require designer privileges on the site for end users who want to upload.
Is this possible without writing new server-side code?
PS government client will not purchase add-on commercial products but they might install free customized server-side programs or web-parts if they can review the code
