I have VBA code that works perfect except for one thing. Currently when I click on the button (Process Data) the code opens a folder and copies some text from all the spread sheets that are in this folder, which works great except that files are being added to this folder every day and if i click on the button (Process Data) a second time it brings in all the files I already have and any new ones which will duplicate the ones when I pushed the button the first time. I ended up adding a clear button that would remove all data and then push the (Process Data) to re-populate the spread sheet. I would like to remove the clear button.
My question is how can I change the VBA code so if more files are added the the folder each day that it only looks at the new files that it has not already transfered data from.
I have attached spread sheet.
Can anyone help!
Bookmarks