View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default automated testing exel applications


"jeff@or" wrote in message
...
Is there a way to do automated gui testing of an excel application?

I have an excel workbook that has custom forms, additions to the menu and
to
the right click context menu. I want to write automated tests which fill
in
information on the forms, cells on the spreadsheet and select special
items
from the menu.

--
-- Jeff


HI Jeff

Try the maco recorder then edit the sub to suite your needs.

N10