Loop through all Excel files in subfolders and run macros in each

Dear Excel Gurus,

I'm very new to the world of VBA, but I need a VBA script which can scan main folder and all sub-folders for "*.xl*" files and run in each sequentially 2 macros: 1) modify header/footer and 2) insert picture. I found two codes and edited them to fit my needs. Ideally, I would like to combine both macros into one and then loop all Excel files with it.

For headers/footers:

Please Login or Register  to view this content.

Insert logo:

Please Login or Register  to view this content.

Last major notice: each workbook should be saved and closed after the macro completes

I will be appreciate for any help Thanks in advance!

I had received compile Error on this line

Please Login or Register  to view this content.

What is a mistake? Do I need to run macro "ScanFolderForXls"?

Dear WBD,

I delete some Reference in VBA project and there is no mistake in this line. But nothing happens with footers/headers in the files...

Where can be error and what I am doing wrong?

Hey Hey,

Sorry it is my fault...I forgot to delete old macros. Everything works, shake your hand again

BR,
Igor