PDA

View Full Version : Code libraries



Killian
03-24-2005, 04:24 AM
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/2004/10/15/code-libraries/#comments at Dick Kusleika's site and cordially invite you back here for your comments :beerchug:

thnx

sandam
03-24-2005, 04:33 AM
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.

TonyJollans
03-24-2005, 06:04 AM
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 :)

mdmackillop
03-24-2005, 06:59 AM
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.

sandam
03-24-2005, 07:09 AM
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.

Anne Troy
03-24-2005, 07:12 AM
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?

johnske
03-24-2005, 07:18 AM
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/showthread.php?t=1230&page=2

I still use it myself...

John

Paleo
03-24-2005, 08:22 AM
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

Brandtrock
03-24-2005, 01:00 PM
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:

TonyJollans
03-24-2005, 01:06 PM
:rotlaugh::rotlaugh:

Games are serious stuff! Coding is just fun.

johnske
03-24-2005, 03:08 PM
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) :)

Anne Troy
03-24-2005, 03:14 PM
Y'all are just sick, sick, sick.

mdmackillop
03-24-2005, 03:26 PM
I find re-inventing the wheel such an enjoyable experience that I keep on doing it :)

Keep up the good work Tony!

Paleo
03-24-2005, 04:37 PM
:rotflmao: :rotflmao: :rotflmao:

TonyJollans
03-24-2005, 05:22 PM
And what's wrong with sick, sick, sick??


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

Paleo
03-24-2005, 05:28 PM
Malcolm - that's a brilliant picture - re-inventing the ground.

:rotflmao: :rotflmao:

Anne Troy
03-24-2005, 05:30 PM
My stomach hurts from laughing at you guys,

NOW CUT IT OUT!!

:rofl: :rofl: :rofl: