Friday, March 11, 2016

Macro - VB script code to extract data from QC (HP ALM)



My understanding:
Note: Suggest to use Head first java book
-        Local variables are variables declared inside the method
-        Static keyword helps to allocate static memory to the variables and methods. What is the use – that way whenever object is created variables and methods in class will be allocated some memory, this happens for each object creation. So for each object creation memory is allocated. Here when you create variable as static, then you cannot have multiple memory allocation. Means address for static variable and method should be constant (cannot change).
              So now how is it useful to have single address?
a.      No duplicates
-        Selenium runs based on JRE, as it is java based application. If one has JRE installed on his machine, he should be able to open Eclipse. But is it necessary to show eclipse where JRE is located, like setting up environment variable to set the path?
-        How about identifying objects in webpage before automating it, like identify all objects in multiple website..that increases your confidence of identifying objects

-         




Thursday, March 10, 2016

Start a Macro When Opening an Excel Spreadsheet

3/10/2016


Rename the macro name to 'Workbook_Open()'. Or sometimes Auto_Open().


or do this

Private Sub Workbook_Open()
'Enter your macro here
End Sub