Use code to list Module names in worksheet

[predetc]

Hi,

Is there an easy way to have VBA code create a list of all the modules you have in your project and put that list onto a worksheet?

Same question with putting a list of all the macros easily into a worksheet.

Thanks!

 

[rmikesmith]

I suppose *easy* is in the eye of the beholder, but Chip Pearson, MS Excel MVP, has a very good explanation + working code to manipulate objects in the VBE, including a specific example to list all modules in a VBProject. Here is a link to the page:

http://www.cpearson.com/excel/vbe.aspx

Regards,
Mike

 

[predetc]

Thanks, Mike. I'll try that.