ECoryn
07-01-2014, 08:16 AM
I need to find all of the files in a Folder that were created and/or modified after a set date (x)
After these files are found, I will need to open each one of them, copy the data contained within them, and paste it into a master spreadsheet.
After doing this, I will reset the date (X) to the date the most recent file that was modified (prior to me opening it).
I believe I know how to do the code to copy and paste the data from one spreadsheet to another; however, I need help on the following code: Finding the newest files (From date X), opening the files, closing the files.
I've seen some codes using Scripting.FileSystemObject or Scripting.Folder or Scripting.File. But I am unfamiliar with what these codes are actually doing and have been unable to modify them for my purposes.
Any help would be much appreciated; I have searched many forums/sites but have had no luck modifying the codes I found in an effective way for my purposes.
(*The codes I have seen, but do not understand:'cpearson.com/excel/getfilename.aspx')
After these files are found, I will need to open each one of them, copy the data contained within them, and paste it into a master spreadsheet.
After doing this, I will reset the date (X) to the date the most recent file that was modified (prior to me opening it).
I believe I know how to do the code to copy and paste the data from one spreadsheet to another; however, I need help on the following code: Finding the newest files (From date X), opening the files, closing the files.
I've seen some codes using Scripting.FileSystemObject or Scripting.Folder or Scripting.File. But I am unfamiliar with what these codes are actually doing and have been unable to modify them for my purposes.
Any help would be much appreciated; I have searched many forums/sites but have had no luck modifying the codes I found in an effective way for my purposes.
(*The codes I have seen, but do not understand:'cpearson.com/excel/getfilename.aspx')