Hello

I have a folder with 1000 spreadsheets that have embedded documents (pdf, word, excel).

I am trying to find or develop a macro that can identify all embedded documents in
a folder with excel spreadsheets and list them in a separate spreadsheets with the file name
of both spreadsheet and embedded document.

Also, I would be grateful if a second macro could be developed to perform the above function and
also embed the documents in a single master spreadsheet.

Thank you in advance!!!

John