SOS for excel VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1541397%22%20slang%3D%22en-US%22%3ESOS%20for%20excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1541397%22%20slang%3D%22en-US%22%3E%3CP%3E15%20different%20workbooks%20saved%20in%20a%20common%20folder%2C%20some%20contain%20data%20and%20some%20doesn't.%20I%20hope%20to%20run%20a%20macro%20to%20determine%20which%20file%20contains%20data%20and%20which%20doesn't.%20Information%20will%20be%20input%20into%20a%20master%20data%20list.%26nbsp%3BBut%20I'm%20not%20sure%20what%20macro%20to%20use.%20Please%20help.%26nbsp%3BThank%20you.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1541397%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1546042%22%20slang%3D%22en-US%22%3ERe%3A%20SOS%20for%20excel%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1546042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F737940%22%20target%3D%22_blank%22%3E%40snowiiy%3C%2FA%3E%26nbsp%3B%2C%20Sounds%20like%20something%20Power%20Query%20will%20be%20able%20to%20handle%20if%20the%20data%20source%20files%20are%20formatted%20alike.%20Click%20on%20Data-%26gt%3BGet%20Data-%26gt%3BFrom%20File-%26gt%3BFrom%20Folder%20to%20get%20started%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22TheAntony_0-1595722240432.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F207930iC18E45FB00724D5E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22TheAntony_0-1595722240432.png%22%20alt%3D%22TheAntony_0-1595722240432.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

15 different workbooks saved in a common folder, some contain data and some doesn't. I hope to run a macro to determine which file contains data and which doesn't. Information will be input into a master data list. But I'm not sure what macro to use. Please help. Thank you. 

1 Reply

@snowiiy , Sounds like something Power Query will be able to handle if the data source files are formatted alike. Click on Data->Get Data->From File->From Folder to get started:

 

TheAntony_0-1595722240432.png