I have a folder with several sub-folders, each sub-folder has several workbooks.
Apart from opening each workbook and selecting each macro, is there a way that I can view/print ALL macros from all sub-folders with a reference to the workbook they belong?
Hello TG58,
It is possible using VBA. Can you provide a sample of how the printout should look?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thank you for your time.
I would like the name of the path to the workbook followed by the actual macro. Thinking about it, I would like this output to a text file so I could print only the bits I need to. Please bear in mind these workbooks are spread over several folders within My Documents.
Again, thank you for your time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks