SirJB7
Excel Rōnin
Hi!
Triggered by a topic created by Lymm with it started with an implementation of Dir statement... Then considering the huge amount of times I needed to find a module or a form that I knew it was there -but finding where was "there" was the problem-, I arrived to a workbook which:
- ask you for selecting a folder
- displays all the files in that folder
- for Excel files it retrieves all object names (worksheets, charts, macros, intl macros, dialogs, modules, class modules, user forms)
- has option for recursive subfolders processing
- has option for cleaning or keeping previous data
- for each object, selecting its cell and pressing a button displays the code within it
Hope you find it useful.
The link?
https://www.dropbox.com/s/5t2x305xz3a09zu/Excel files documenting & inspector.xlsm?dl=0
Comments and suggestions are welcome.
Regards!
Triggered by a topic created by Lymm with it started with an implementation of Dir statement... Then considering the huge amount of times I needed to find a module or a form that I knew it was there -but finding where was "there" was the problem-, I arrived to a workbook which:
- ask you for selecting a folder
- displays all the files in that folder
- for Excel files it retrieves all object names (worksheets, charts, macros, intl macros, dialogs, modules, class modules, user forms)
- has option for recursive subfolders processing
- has option for cleaning or keeping previous data
- for each object, selecting its cell and pressing a button displays the code within it
Hope you find it useful.
The link?
https://www.dropbox.com/s/5t2x305xz3a09zu/Excel files documenting & inspector.xlsm?dl=0
Comments and suggestions are welcome.
Regards!
Last edited:
