- Albert Gareev
- Blog
- Testing Stories
- Automation Chapters
- Resources
Test Engineering, Test Automation … Professional Development, Management, Community Building
Recent Posts
Active Directory Scripting – create User Account
Posted by Albert Gareev on Feb 16, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to create User Account Description User Account object could be created within its container object – Organizational Unit. The example below is based on ...
Active Directory – Sample Scripts (Excel/VBA)
Posted by Albert Gareev on Feb 14, 2010
Basic Active Directory Queries How to retrieve Organizational Unit How to retrieve User Account How to retrieve Security Group Working with Active Directory Objects How to create User Account How to create Security Group How ...
Active Directory Scripting – retrieve Security Group
Posted by Albert Gareev on Feb 12, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve Security Group Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to ...
Active Directory Scripting – retrieve User Account
Posted by Albert Gareev on Feb 11, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve User Account Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to successfully ...
Active Directory Scripting – retrieve Organizational Unit
Posted by Albert Gareev on Feb 10, 2010
Reference page: Active Directory – Sample Scripts (Excel/VBA) How to retrieve Organizational Unit Description Build LDAP Query – Execute Query – Catch Errors Note. You need to login as an authorized person to ...
IT Infrastructure Maintenance: Introduction
Posted by Albert Gareev on Feb 09, 2010
Infrastructure – the basic, underlying composition of elements and their connections that form a system. In IT “infrastructure” is a layered definition. It includes electrical and communication lines, and ...
Blog migration complete!
Posted by Albert Gareev on Feb 04, 2010
Blog contents migration has been completed.
Read the entry to see what plugins were used on Wordpress platform.
...
How to find-replace empty cells (Excel, QTP, VBScript)
Posted by Albert Gareev on Jan 29, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Open worksheet – Loop through data range – close and save the workbook. Note. ...
How to find Excel worksheet by name (QTP, VBScript)
Posted by Albert Gareev on Jan 27, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Loop through worksheets – close and save the workbook. 1. If you know Excel Worksheet ...
How to check if folder exists (QTP, VBScript)
Posted by Albert Gareev on Jan 24, 2010
Parent page: Service Functions – System (QTP, VBScript) Use FileSystemObject.FolderExists method. Argument should be a full path string. When to use it? Always before trying to access the folder (delete, rename, or read ...
How to add (create) Excel macro from QTP
Posted by Albert Gareev on Jan 21, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Retrieve Code Module object – Add new macro string – close and save the ...
How to enlist Excel VBA macros (QTP, VBScript)
Posted by Albert Gareev on Jan 20, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Retrieve Code Module object – Retrieve Code Block string – Parse the ...
How to exchange parameters with Excel VBA function (QTP, VBScript)
Posted by Albert Gareev on Jan 15, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers 1. To pass-in parameters to an Excel VBA function A function must be public and belong to a Macro Module. QTP/VBScript source code Excel/VBA function source code ...
How to call Excel VBA function from QTP
Posted by Albert Gareev on Jan 14, 2010
Parent page: Service Functions – Excel (QTP, VBScript) Answers Description Connect to Excel through COM – Open workbook – Invoke the function – Catch error – close and save the workbook. Notes. ...
Service Functions – Excel (QTP, TestComplete, VBScript)
Posted by Albert Gareev on Jan 12, 2010
In the code examples I present I often refer to routine functions. In my framework I have specialized libraries to call from. In my blog I maintain the similar structure. Functions Excel File Worksheet compare (QTP, VBScript) ...
Independent hosting
Posted by Albert Gareev on Jan 10, 2010
This one is to announce that Automation Beyond blog has moved to an independent web hosting service.
Maintenance works ahead. ...
How to update value in XML file (QTP, VBScript)
Posted by Albert Gareev on Dec 30, 2009
Parent page: Service Functions – XML (QTP, VBScript) Answers Description Open XML file – load into memory – locate target nodes – update (replace) values – save XML file (either under a new name or ...
How to count XML nodes (QTP, VBScript)
Posted by Albert Gareev on Dec 29, 2009
Parent page: Service Functions – XML (QTP, VBScript) Answers 1. How to count all direct children? 2. How to count all direct children, specific name tag? 3. How to count all descendants? References Read more about XPath ...
GP/QTP Automation: Conclusion but not closure
Posted by Albert Gareev on Dec 28, 2009
GP/QTP Automation: Conclusion but not closure The main question – whether it’s possible to automate Microsoft Dynamics Great Plains application testing (OS Patch smoke tests, UAT/Regression tests) – was ...
GP/QTP Automation: Execute Dexterity Macro
Posted by Albert Gareev on Dec 23, 2009
All related posts: Reference Page – GP/QTP Automation Dexterity Macro Limitation and Suggested Workaround One of the major limitations identified in Dexterity Macro System is totally hard-coded data with no functionalities ...
How to use loops in Dexterity Macro
Posted by Albert Gareev on Dec 21, 2009
All related posts: Reference Page – GP/QTP Automation Answer According to the documentation, there are no loop operators defined in Microsoft Dynamics Great Plains Dexterity Macros. However, the macro language provides ...
How to create a unique subfolder (QTP, VBScript)
Posted by Albert Gareev on Dec 16, 2009
Parent page: Service Functions – System (QTP, VBScript) How to create a unique subfolder Description A subfolder is created based on the name pattern and a date-time stamp, e.g. “AccountSearch 2009-10-14 ...
How to duplicate an existing file (QTP, VBScript)
Posted by Albert Gareev on Dec 15, 2009
Parent page: Service Functions – System (QTP, VBScript) How to duplicate an existing file (If you want to access the file but it’s locked) Description sFileName – name of the file to duplicate sNewName – name of ...
How to generate unique file name (QTP, VBScript)
Posted by Albert Gareev on Dec 14, 2009
Parent page: Service Functions – System (QTP, VBScript) How to generate a unique file name if the file name already exists in the given folder (That often happens, if you need to create a series of files or duplicate an ...
Generating text file from XML template (QTP, VBScript)
Posted by Albert Gareev on Dec 09, 2009
Parent page: Service Functions – System (QTP, VBScript) Description If you need to generate text file with values you don’t know ahead you may do it dynamically, by utilizing the function below. Make sure ...
GP/QTP Automation: Creating Dexterity Macro XML template
Posted by Albert Gareev on Dec 07, 2009
All related posts: Reference Page – GP/QTP Automation Dexterity Macro Limitation One of the major limitations identified in Dexterity Macro System is totally hard-coded data with no functionalities to read them from any ...
Service Functions – System (QTP, VBScript)
Posted by Albert Gareev on Dec 05, 2009
In the code examples I present I often refer to routine functions. In my framework I have specialized libraries to call from. In my blog I maintain the similar structure. FileSystemObject (FSO) FileSystemObject is a primary ...
Blog maintenance ahead – source code formatting
Posted by Albert Gareev on Dec 04, 2009
Blog maintenance ahead – source code formatting Thanks for the new plugin implemented in Alex Gorbatchev’s SyntaxHighlighter project. The all pages containing code examples will be updated. New Look The example below is ...
Text File Compare Report example (XML, XSL, HTML)
Posted by Albert Gareev on Dec 03, 2009
Root page: Service Functions – XML (QTP, VBScript) Parent page: XSL introduction and references Related post: Text File compare in “WDIFF” style (QTP, VBScript, XML, XSL) – Instructions and XSL script Sample task ...
XML verification example (XSL, HTML)
Posted by Albert Gareev on Dec 02, 2009
Root page: Service Functions – XML (QTP, VBScript) Parent page: XSL introduction and references Sample task Verify “transactions” xml file consisting of 10-1000 records. Only “debit” or ...
