Student Mode Code Display

Welcome to the Fraternity!

Commenting has been enabled. You can comment on all the Code Items now.

Compare Two Excel Files


Add This Code to My Favourite List
Enter Email

Contributed By Sandeep Jadhav
Date 2016-04-12 10:07:45

' Compare two excel files 

'create two excel sheets compare1.xls and compare2.xls
'compare1.xls contains  
'10     15
'20     16
'30     17
'31     18
'32     13
'33     21
'34     22
'35     29
'36     34
'37     37
'21     40

'Compare2.xls contains  
'10     15
'20     16
'30     17
'31     18
'32     13
'29     21
'34     57
'35     29
'36     34
'37     41
'21     40


Set xl=createobject("Excel.Application")
xl.visible="True"

'Open workbook s to compare
Set compare1=xl.workbooks.Open("D:\WORK\QTP\QTPSTUFF\Datasheet\Compare1.xls")
Set compare2=xl.workbooks.Open("D:\WORK\QTP\QTPSTUFF\Datasheet\Compare2.xls")

Set CompareSheet1=compare1.sheets("sheet1")
Set CompareSheet2=compare2.sheets("sheet1")

For each cell in CompareSheet1.UsedRange
  If cell.value <>          C     compareSheet2.Range(Cell.Address).value Then

                ' highlight the cell if mismatch exist
        cell.Interior.ColorIndex = 6
        End If
Next

'Close workbooks
Compare1.close
Compare2.close

'Close the application
xl.Quit

Download Above Code

Comments:


Updated by RichardReutt at 2017-09-22 09:19:38
301 Moved Permanently
<a href=https://www.viagrapascherfr.com/>301 Moved Permanently>>></a>
Updated by TerryRof at 2017-10-02 08:49:43
Doctor Who is now considered a British Institute and has come a long way since it first aired on November 23rd 1963. The very first show saw the Doctor travel 100,00 years into the past to help some dim cavemen discover light. After 26 seasons and seven Doctors later the series came off our screens in 1989 much to the disappointment of the huge devoted fanbase. In 1996 an attempt was made to revive Doctor Who but it wasnt until June 2005 when it came back with a vengeance with Christopher Eccleston as the ninth Doctor that put the series back on the map as it were. It then went on for 5 years with David Tenant portraying the Doctor until 2010 when Matt Smith took over the role. Today it is still a great family show and has attracted many new fans.

If youre a new or old fan of the show there are Tours and museums you can go and see some of the locations and memorabilia of this classic show. The Doctor Who Tour of London will take you on over 15 locations from the show, some from the new series and some from old sites like the location of The Invasion and Resurrection of the Darleks. The tour also takes you to the TV museum in London where you will get to see some of the cosumes worn in the show and props used. Also you can buy gifts and memorabilia from the shop.

You will learn all about how the shows were made so the tour is also educational. If you want to take pictures of the locations thats not a problem. Remember the front door of 10 Downing Street in Aliens of London? Well you can get up and close to this and get your picture taken in front of the door. Rose Tyler fans will love the tour as you get to drop by her home in the show.

Why not go that extra mile and actually meet a Doctor Who star. Well this is possible with private or group tours. You will get the general tour but included will be a pre-arranged meeting or lunch with a celebrity from the show. This will obviously depend on availability of the celebrity and the cost will reflect the popularity of that celebrity.

There are tours in London and also Wales. The Wales tours take you to Cardiff where you will see lots of location which were featured in shows since 2005. You can leave from London or at Leigh Delamere services station on the M4. There is a Doctor Who exhibition in Cardiff which you get to see. At the end of the Doctor Who tour you get a souvenir group picture sent you by email which is a nice touch.

For seriously devoted Doctor Who fans there is a 3 day tour which takes you to all the locations in both London and Cardiff. You will see locations from the past 45 years as well as recent sites from the lasted Doctor Who series. Day one is based in London where you get to see 15 sites. Day two takes you to Cardiff where you get to mean the real life owner of the to see we have an Gothic property used as the location of the school in Human Nature. The final day is partly spent in Cardiff with a walking tour at Cardiff Bay, then you head back to London but a stop at Stonehenge to see the site of the Pandoica. Then its dinner at The Cloven Hoof pub in Devils End b efore you taken back to central London.

 

Add your comments...
Name : *      
Email : *      
The content of this field will be kept private and will not be shown publicly

Your Comment/Answer *

Enter the text present in this box : *