Hi Chris Due to the security reasons, this is not possible through VBA/VSTO.
Regards Ashish Jain McKinsey India Knowledge Center (Microsoft Certified Application Specialist) (Microsoft Certified Professional) http://www.excelitems.com http://www.openexcel.com On Oct 20, 7:06 pm, ChrisDixon <chrisjdi...@rocketmail.com> wrote: > 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