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

"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

I tried that. The macro recorder only records interactions with the
worksheet, not the custom forms or custom menus.

--
-- Jeff