With Workbooks(ComboWB.ListIndex + 1).VBProject.VBComponentsįor i = 1 To Workbooks(ComboWB.ListIndex + 1). ' Find all components for selected WorkBook, and identify their Types

This KB provides a front end to those commands.ĪCHTUNG! It would be a good idea to use COPIES of your WorkBooks with this code, as mistakes may or may not be reversed easily.

Microsoft suggests that you use Excel 2003 (Windows) to export components if you need to! The good news is that the Import / Export commands can still be accessed through VBA. Not designed for Windows (although it might work).įor some unknown reason Microsoft failed to include Import / Export commands in the VBE on Mac Office. Enables Mac users to import / export VBE components (class modules, userforms, standard modules) to / from open WorkBooks.