The online community for software testing & quality assurance professionals
Calendar   Today's Topics

Lost Password?


Software Testing >> Automated Testing

Pages: 1

Reged: 09/04/07
Posts: 82
Tool to test Excel VBA application
      #718494 - 10/22/12 03:32 AM


I want to perform an automated test on an application.
The application is a complex Excel sheet, driven by VBA macro's.

Do you know a tool that I can use to test the application quickly by record and playback?

Somewhere else in this forum I read that AutoIt, WinTask and TestComplete are good candidates. Has someone experience with this?

I also explored testing by the record and playback macro functionality of Excel itself. Or copying and pasting the recorded excel-macro's in QTP.
But this takes too much programming and tidying up.

What solution do you advice?

Post Extras: Print Post   Remind Me!   Notify Moderator  
Joe StrazzereModerator

Reged: 05/15/00
Posts: 12344
Loc: Massachusetts, USA
Re: Tool to test Excel VBA application [Re: eriktv3]
      #718507 - 10/22/12 05:31 AM

WinTask has some built-in functions in its scripting language that might help. These functions can retrieve data from spreadsheets, execute Excel macros, etc.

While I haven't used Excel to test a complex Excel sheet, I have used it extensively reading and writing data from Excel spreadsheets. It works quite well for me.

I doubt that you'll get by solely depending on record and playback, though - using WinTask, or any other tool. If recording then modifying scripts isn't your thing, you might want to recruit someone to help you.

- Joe
Visit to learn more about quality, testing, and QA!

I speak only for me. I do not speak for my employer, nor for anyone else.

Post Extras: Print Post   Remind Me!   Notify Moderator  

Reged: 09/04/07
Posts: 82
Re: Tool to test Excel VBA application [Re: Joe Strazzere]
      #718528 - 10/22/12 10:00 AM

Thanks Joe!

I will look into WinTask.

Modifying scripts really is my thing. I have experience with VBA for Excel and with QTP.
Using QTP seems not smart to me, as I should use the recorded VBA Excel macros en paste them in QTP. Then better use Excel VBA directly.

The problem is speed. I need to create a lot of test automation within a few weeks. So, I don't want to spend too much time on scripting.

Post Extras: Print Post   Remind Me!   Notify Moderator  
Pages: 1

Extra information
0 registered and 11 anonymous users are browsing this forum.

Moderator:  Elfriede Dustin, AJ, Joe Strazzere 

Print Topic

Forum Permissions
      You cannot start new topics
      You cannot reply to topics
      HTML is disabled
      UBBCode is enabled

Topic views: 3443

Rate this topic

Jump to

Contact Us | Privacy statement SQAForums

Powered by UBB.threads™ 6.5.5