Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default unit testing code using vba

Not a new idea, but I haven't seen anything out there that has worked for
me, so I built some classes to facilitate unit code testing. It works for a
given module, but now I'd like to apply the same idea to the project.
Strategy I'd like to figure out how to implement is:
1) common Public name in code module to test, "zTestSuite"
2) add test dedicated module to project, "zUnitTest"
3) get a collection of all codeModules
(Application.VBE.ActiveVBProject.VBComponents)?
4) runt the procedure if present, skip if error (Application.Run??)

Obviously half-baked still, but I'd rather not invent a wheel if it's out
there? Anyone doing anything solely with VBA that is quick and effective?

Thanks! Eric


Reply
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
Unit Compatibility kara Excel Discussion (Misc queries) 1 October 27th 08 04:15 PM
Testing code for oldest version... John Keith[_2_] Excel Programming 1 October 25th 05 03:16 PM
CF for over/under mean unit marcy Excel Worksheet Functions 1 April 21st 05 05:42 PM
unit testing advice Eric[_27_] Excel Programming 3 February 21st 05 09:23 AM
testing the state of a checkbox in vba code Paul James[_3_] Excel Programming 10 December 5th 03 07:55 PM


All times are GMT +1. The time now is 02:01 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"