|
| SeleniumWiki |
| Visit this group |
I am using Excel to store the test data and use Visual Studio 2010 C# to code the selenium scripts. When running the scripts I was getting the TF80070 error. I had to click on the confirmation box to continue testing. So it when from automation testing to manual testing (because of the error message).
Anyway here is the solution.
Open excel and then go to excel options. Select Add-Ins and the from the manage select list select COM Add-ins. From the COM Add-ins uncheck Team Foundation Add-in check box. This will stop the annoying error message from appearing.
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
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
