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

-         

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

Hervey Ball

- Hervey balls:

Harvey Balls are round ideograms used for visual communication of qualitative information. They are commonly used in comparison tables to indicate the degree to which a particular item meets a particular criterion.

One could create Harvey Balls in Excel, using Conditional Formatting -> Icon Sets->select the circle icon.

Note: Deleted the blog that says: Creating circles that dynamically change based on the % mentioned (like 23% completed, should show up 23% of circle shaded).