I have a problem that could easily be solved using Microsoft Visual Basic For Applications Extensibility, but cannot enable the 'Trust Access to the VB Project Object Model' setting, so must find another solution
>From within Workbook A, I want to retrieve a list of forms, modules, functions and subs from Workbook B. Either of the following methods would be fine: Workbook A to pull the details from Workbook B Workbook B to push the details to a text file and Workbook A to pick up the text files Does anybody know of a way to get these details out of Workbook B without resorting to VBE? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
