Getting VBA from Spreadsheets and Saving as TXT files

[Alex20850]

I have a list of spreadsheets that may or may not have macros and functions in them.
I am looking for a macro that would:
Look at each file in a list of spreadsheets in Excel 2010 or 2016,
Open each spreadsheet and
if there is code for a macro or a function save into a text file named the same as the spreadsheet.

 

[jolivanes]

Have a look here. About halfway down the page where it says "Exporting A VBComponent Code Module To A Text File"

Programming In The VBA Editor