Code libraries

I was wondering how the VBAX crowd managed their existing code since I need to get myself organized in this respect. Rather than blather on I'll just point you to this thread http://www.dicks-blog.com/archives/2...ries/#comments at Dick Kusleika's site and cordially invite you back here for your comments :beerchug:

thnx

I organise my code badly, also email all my revisions on my projects to myself as a back up. I'd say a well organies archive directory with cut and paste would be my choice. As long as the modules are well named you shoudl always be able to find what you're looking for.

Afraid I'm one of the disorganised - and not just with VBA.

I keep everything in my head and the retrieval mechanism is about 1% effective. I find re-inventing the wheel such an enjoyable experience that I keep on doing it :)

I made a VB6 routine a while ago to assist with this, but I never got organised yet to store my code in the spreadsheet. Basicaly the selected code is copied to the clipboard, the current Excel/Word VBE opened as selected, and Ctl+V pastes the code where you want it.

lol. I've lost tons of code that way myself :) Especially the stuff I did in univeristy for the final year project. Oh man, for the understanding of VB/Access interaction I had back then.

So. What's wrong with the VBAX KB? :dunno

What do we need to do to make it "your code library"?
Should we be giving people private entries?

Hi Guys,

Have a look through this thread I started a while back - an Excel VBA code library - lotta ppl came up with some good ideas there > http://www.vbaexpress.com/forum/show...?t=1230&page=2

I still use it myself...

John

Hi guys,

I comment every single line of code telling me (for future reading) what I am doing and why, then I separate every sub in a file named (Application-Functionality. Ex.: Excel-Find specific cell).

After that I save it on a CD. Plus every work I do I save on a CD inside a directory named after the client in a subfolder named by the date I have finished the job.

Well, dont know how good it is, but its my system.:dunno

Quote:

---

Originally Posted by TonyJollans

I keep everything in my head and the retrieval mechanism is about 1% effective.

---

Sounds like a new use for the paper and pencil routine that helped with Simon. :rofl:

:rotlaugh::rotlaugh:

Games are serious stuff! Coding is just fun.

Quote:

---

Originally Posted by TonyJollans

I find re-inventing the wheel such an enjoyable experience that I keep on doing it :)

---

I like that - after all, why experience the joy of discovery only once? :thumb (And just think how happy ppl with Altzheimers must be - looking forward to it now) :)

Y'all are just sick, sick, sick.

Quote:

---

Originally Posted by TonyJollans

I find re-inventing the wheel such an enjoyable experience that I keep on doing it :)

---

Keep up the good work Tony!

:rotflmao: :rotflmao: :rotflmao:

And what's wrong with sick, sick, sick??


Malcolm - that's a brilliant picture - re-inventing the ground.

Quote:

---

Originally Posted by TonyJollans

Malcolm - that's a brilliant picture - re-inventing the ground.

---

:rotflmao: :rotflmao:

My stomach hurts from laughing at you guys,

NOW CUT IT OUT!!

:rofl: :rofl: :rofl: