VBA / TP
Our company has decided to go all out with QA automation using Test Partner.
The sales guy told us that we can use VBA.
I have now been assigned to start some kind of a systematic approach to developing test scripts.
I had some basic questions:
1.What is 'Using VBA' - i am familar with VB, can i develop Classes/Objects/Modules in VBA and use them in TP.
Do i need to register DLL's etc.
2.I have loads of data / how do i store these. My preference is a database. Can i do it in a database. If so do i have to develop my own database structure.
Any responses will be very helpful
thanks in advance.
Re: VBA / TP
VBA is VisualBASIC for Applications.
I believe you can do ActiveX DLLs using newer versions of Access. You may want to conduct your own research on this. Registering DLLs. It never hurts to register them. You can also write DLLs in VB, C, or other and call them from within VBA.
Data you can store in the most comfortable medium for you, be it DB, Spreadsheet, flatfile, etc. I recommend a db. MS-Access, VBA and ADODB give you lots of flexibility.
Data-structures (assuming you are talking about test data for use in data-driven tests):
You would have to define your tables and relationships. The flatter the db, the better in my opinion. No production-deployed end-user has to look at this data or be concerned about how optimized it may be.