LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default tips for organizing code for distribution

Any good articles for maintenance of code?

I currently use just the VBA Office comes with for work, and although I'm
not in IT, I'd like to be able to distribute some stuff with code to users.
Some of the reasons I don't include:
1) the security issue - my IT department says it can get me a cert for
$90/year, but I'm thinking I could avoid this if I either used add-ins to
distribute the code, or invested in VB6 and compiled the code (at least I
think those would work)
2) maintenance - I'm wondering what other people do, cause it seems like a
nightmare, particularly if you want to be able to modify code either at work
or at home. Is there a CVS version for VBA? Any utilities out there for
managing projects?
3) off topic but related - I'd love to be able to use unit testing along the
lines of junit. Currently I write a little test with a conditional compile
(i.e., ccDebug = 1), but it's not very elegant or robust. I've tried vbaUnit
and vbLite, but wasn't particularly impressed with either. Maybe another
reason to move up to VB (how much is that anyway?)

Thanks, Eric


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
General tips for good code formatting NDBC Excel Discussion (Misc queries) 3 August 12th 09 07:36 AM
Sources of Excel Tips, Tricks & Code John James Excel Discussion (Misc queries) 6 April 3rd 06 08:51 PM
organizing a workbook mrbillmsn Excel Worksheet Functions 3 September 13th 05 12:36 AM
Help organizing date Nina Excel Discussion (Misc queries) 1 August 19th 05 06:05 PM
Organizing functions Knut Dahl Excel Programming 6 April 21st 05 11:18 AM


All times are GMT +1. The time now is 12:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"