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" <(E-Mail Removed)> wrote in message
news:1C7BB21A-E02E-4108-9B2A-(E-Mail Removed)...
> 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