Stephan Dekker

If you are out to describe the truth, leave elegance to the tailor. (Albert Einstein, 1879 - 1955)

Browse by Tags

All Tags » Excel automation (RSS)
Sorry, but there are no more tags available to filter with.
Export all the Excel 2007 modules to file
Create your own VBA module in Excel: Sub exportAllModules() ' reference to extensibility library Dim objMyProj As VBProject Dim objVBComp As VBComponent Set objMyProj = Application.VBE.ActiveVBProject For Each objVBComp In objMyProj.VBComponents If...

Posted by Stephan Dekker

Filed under: