TFS Visual Studio 2010 and Excel Integration TF80070 error – Selenium Excel Test Data

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.

Change date format to australian data format with excel macro VBA.

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.

Normally when you print the date from a excel spread sheet to a text file the data is printed as dd/mm/yyyy.

if you have the date 10/06/2010 in cells(1,1)  using Format(Cells(1,1), “dd-mmm-yyyy”) you can print the date as 10-Jun-2010.

Print #FileNum, Format(Cells(1, 1), “dd-mmm-yyyy”)

How to extract the first 100 characters from a excel cell using vba

In this example I will tell you how you can extract the first 100 characters from a excel cell using vba

Say Call A1 has the value In this example I will tell you how you can extract the first 100 characters from a excel cell using vba

In Cell B1 write the function =MID(A1,1,100). You will see cell B1 will have the text In this example I will tell you how you can extract the first 100 characters from a excel cell using.