Get hold of a copy of Rob Bovey's indispensable Code Cleaner utility,
http://www.appspro.com/Utilities/CodeCleaner.htm

Although he calls it CodeCleaner, as it works by exporting all modules and
re-importing them, Rob provide an option to just export.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ullrich Fischer" <Ullrich wrote in
message ...
I would like to find a way to reduce the amount of time it takes to export
all the VBA source code from a spreadsheet to a text file in Excel 2007.
Currently, I click on each module in turn, then go to File, Export, etc.