Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1142
  • Last Modified:

Code Coverage Analysis of VBA Code

I need to perform a code-coverage analysis on an Excel-VBA based application.

I am searching for tools that would read excel(.xls) files and give a report on statistical analysis of code like dead-code, % of code covered by test cases e.t.c.

Any reply in this matter is highly appreciated.

Regards,

S. Shashidhar
0
Shashidhar_100
Asked:
Shashidhar_100
1 Solution
 
mlmccCommented:
You might look at
http://www.aivosto.com/vb.html

They produce code analyzers for VB that do what you want.  The tools might be able to work with VBA.

mlmcc
0
 
DanRollinsCommented:
Hi Shashidhar_100,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days. I will ask a Community Support Moderator to:

    Refund points and save as a 0-pt PAQ.

Shashidhar_100, Please DO NOT accept this comment as an answer.
EXPERTS: Post a comment if you are certain that an expert deserves credit.  Explain why.
==========
DanRollins -- EE database cleanup volunteer
0
 
SpideyModCommented:
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now