automated testing exel applications

[Guest]

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.

 

[N10]

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.

HI Jeff

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

N10

 

[Guest]

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