House Keeping of Macros

[VKS]

Dear Experts,
In my endeavor to learn VBA, I have created more than 25 modules. Some macros created with the help of forum member are excellent piece of work and I use them often. My problem, I want to clean it up now but before doing that I want all of them to be saved as text or word so that I can copy and paste them at latter stage.
Purpose of doing this is to have limited number of modules(lets say only three modules )
1. For work - Module 1
2. For personal stuff (that works fine and used often) – Module 2
3. Learning Macros (I park only those which I create and use as hit and try) – Module 3
Wondering if its worth thinking like this. Any guidance/Suggestion on this would be much appreciated.
Best Regards/VKS

[Jakobshavn]

I would re-name the modules:

http://www.excelforum.com/excel-prog...le-in-vba.html

and then Export them.

[VKS]

Thanks a lot. I shall go and check the link.

[Richard Buttrey]

Hi,

Are we talking about macros in your personal workbook here?

It's really a case of what's important and useful to you. I must admit I tend to keep macros that do similar things in the same module, i.e. on a functional basis rather than your proposed occasion basis.

If your question is about editing them then just use file export in the VBE and save all the resulting .bas files which you can then open with any text editor such as Word, Notepad etc.

[VKS]

Hello Richard, These are all in personal workbook and now i am finding it tough to locate useful macros thats why i want to save them all and start new modules. On second thought other option could be delete a few unwanted or failed macros a day but then i have this risk of having all 25 modules with one macro each

[Richard Buttrey]

Hi,

There is nothing of course to stop you doing both and having the same macro in two sets of modules.

You could have three modules using the 'Occasion' layout and another set of 25 or whatever modules for the 'Functionality' layout.

[VKS]

Dear Richard and Jacob,
You have my stars for opening up my thought process.
Best Regards/VKS

[Sean Thomas]

I just copy the code from the modules and save them in word documents.
that way i can save them under certain headings in a folder for easy access later
i.e:
E-mail
pdf
last used row
find
protection
loops
etc.etc

just need to set the word doc to not look for corrections and then you can copy and paste easily.

[abousetta]

I use txt files as they carry no formatting, are smaller file sizes than Word and I have found that Word sometimes causes problems with characters like the apostrophe and quotation marks. When pasted back into a module, Excel often does not recognize the character and errors out.

Hope this helps.

aboustta