Iceberg Code

Thank you visiting ICB - Iceberg Code Blog
This is the place, where I'd like to share ideas and some useful code (VB, Excel, T-SQL, JavaScript, ...)
Table of Content

In previous post you selected unique files (ANY) and now you'd like
to search inside all the beautiful VBA code you written or you got there
or elsewhere.

For this reason I found a elegant solution on the web and
I improved a little (I just put an interface to it)

ExportCode.xls

Note: to use this particular macro you have to change
an Excel setting (if you don't you'll get nothing):

So just follow the Excels Menus
[Tools][Macro][Security...] to [Trusted Sources]
and activate "Trust access to Visual Basic Project"

After you run it you get a lot of *.cod files and maybe
you'd like to merge all them to better search inside with
a text editor (I use ultraedit).

To do this you just need a simple batch file:
copy and paste this one-row code in a file you call "Merge.bat"

copy *.cod Merged.txt

... and run it, now you have a big file with all your VBA code to search inside!