PC Review


Reply
Thread Tools Rate Thread

automated testing exel applications

 
 
=?Utf-8?B?amVmZkBvcg==?=
Guest
Posts: n/a
 
      21st Mar 2007
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
 
Reply With Quote
 
 
 
 
N10
Guest
Posts: n/a
 
      21st Mar 2007

"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


 
Reply With Quote
 
=?Utf-8?B?amVmZkBvcg==?=
Guest
Posts: n/a
 
      22nd Mar 2007
I tried that. The macro recorder only records interactions with the
worksheet, not the custom forms or custom menus.

--
-- Jeff


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automated Regression Testing? PeteCresswell Microsoft Access 5 31st May 2009 06:05 AM
Why does Exel open much slower than other applications? Andre Microsoft Excel Misc 0 24th Mar 2009 08:37 PM
Automated Security Testing Fresno Bob Microsoft ASP .NET 2 28th Jul 2008 12:05 AM
Automated Testing Software? kiln Microsoft Access VBA Modules 6 26th Feb 2005 01:09 AM
Automated Testing software Alvin Bruney Microsoft ASP .NET 1 20th Nov 2003 07:35 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:28 AM.