I have an excel file that i use to copy files from one place to another putting dates on the end of the files.
The files are scheduled to deliver to a folder daily.
Excel is pre-populated with all the information required and contains the vba to carry out the task but it takes a long time to complete and excel hangs.
I am looking for a vbs script that can look at the excel file to get the info and copy the files.
The excel file has the following columns to use.
Column A equals Source Path
Column B equals Source File Name with extention
Column C equals Destination Path
Column D equals Destination File Name with extention
Column E equals File Requires Date Stamp YESorNO
Column F equals Delete File After Transfer YESorNO
Column G equals NEW Destination File Name with extention If Column E equals YES
Column H equals Created Date of File Check Source File Info VBS adding to Sheet
Column I equals Last Modified Date of File Check Source File Info VBS adding to Sheet
Column J equals Time Last Modified Check Source File Info VBS adding to Sheet
Some sort of file name progress meter would be great if possible.
Loop and start again from top but have some way of stopping if needed
If error is found that stops vbs, email there is an issue before fail.
Last thing a big ask and not sure if possable
Column K equals Source File Name Only No Extention
Column H equals Created Date of File
Column I equals Last Modified Date of File
Column J equals Time Last Modified
When a file is successfully transfered, upload/Append the details above to a SharePoint List
If Not Possable and this is possable, Copy/append Successfull transfer info to an excel speadsheet, if time = 4pm finish current run, email list of successfull transfers today. list all files data and time & summary Transfered not Transfered.
I understand this is a big ask, but i could really do with the help before my current method either overheads my base unit or fails all together.