|
| SeleniumWiki |
| Visit this group |
In this example I will tell you how you can use Proper Case Function in Excel Macro VBA.
Application.Proper(Cells(r, 1)).
You can not use Proper(Cells(r, 1)) .
In this example I will tell you how you can change the date format to Australian data format (DD-MMM-YYY) with excel macro VBA.
In this example I will tell you how you can extract the first 100 characters from a excel cell using vba
Using Excel VBA Trim function with xpath in selenium.
Abstract = "//textarea[@id='ctl00_MainContent_ArticleTabPages_txtAbstract'][contains(text(),'" & Trim(Cells(r, 4)) & "')]"
Microsoft Visual Basic Error – Methord or Data member not found
This error is generated when you call a function that is set a private. To resolve the issue change the function from Private to Public.
How to find the last row in an excel sheet:
ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
Here is an example
Dim LastRow As Long
LastRow = ActiveSheet.Cells.SpecialCells(xlCellTypeLastCell).Row
For r = 1 To LastRow
