I have a colleague who wants to derive some code development
tracking metrics for our CVS hosted products. This needs to
be done using a Microsoft Excel spreadsheet in a relatively
automatic way. What he would like is to be able to execute
CVS commands, or use some DLL or ActiveX type functionality
from a Excel VBA to get information back to the spreadsheet.
Has anyone done this?
(For the record, he is currently checking out to a UNIX area,
then building an Oracle database with metrics derived from that
area. The Oracle database is then queried using ODBC from Excel
VBA. There has to be a better way!)
#!/mjh
