Forum Discussion

Copper Contributor

Mar 13, 2018

Extract Data from All Files w/ a Last Modified Date Between 02/01/2018 and 02/24/2018

Hi Everyone, I have a folder with Excel files that are completely standardized in terms of the type of data in specific cells. What I am hoping to be able to do is to have the VBA code only ret...

Macros & VBA

VBA

Jamil

Bronze Contributor

Mar 13, 2018

I assume you know the basics of the VBA, so this will get you started.

You will need to use the Microsoft Scripting Runtime.

Set oFile = CreateObject("Scripting.FileSystemObject")
if oFile.getFile(Directory & FileName).DateLastModified >= EarliestDate and oFile.getFile(Directory & FileName).DateLastModified <= LatestDate