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")

'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

'Close workbooks

'Close the application

Download Above Code


Updated by RichardReutt at 2017-09-22 09:19:38
301 Moved Permanently
<a href=>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.

Updated by buy kamagra 100mg at 2018-03-28 18:43:21
kamagra oral jelly 100mg suppliers australia
<a href="">kamagra 100mg tablets use</a>
kamagra kopen
<a href="">kamagra 100 chewable polo</a>
kamagra forum
kamagra novi sad
Updated by kamagra store uk at 2018-03-30 09:18:56
kamagra stores
<a href="">kamagra 100mg tablets for sale usa</a>
kamagra 100 chewable tablet einnahme
<a href="">kamagra 100mg 7 tablets</a>
kamagra jelly reviews
kamagra oral jelly amazon
Updated by KlqrtzSi at 2018-10-14 01:26:46
can you buy viagra in spain
Updated by MuzaklSi at 2018-10-14 09:39:27
viagra pills for cheap
Updated by KiozilSi at 2018-10-15 10:24:00
buy cytotec laguna
Updated by KelCyhows at 2018-12-16 22:10:08
Buy Doxycycline On Line Cialis Precio Lima <a href=>viagra</a> Viagra Flussig Is Keflex Good For Teeth Nfection <a href=>vente levitra en france</a> Acheter Cialis A Lyon Brand Levitra 20mg Online India Canada Cheap Antibotics Usa Rx Pharmacy Viagra Generic <a href=>cialis prices</a> Where To Buy Diclofenac Sodium Cialis Duracion Del Efecto Canadian Vigra Cialis Generique Maroc Levitra Samples <a href=>viagra</a> Doxycycline 100mg Canada Ampicillin For Cheap Canadian Drugstore Viagra Amoxil Sans Ordonnance <a href=>cialis online</a> Levitra Zonder Recept Viagra Para Mujeres Amoxicilina Antibiotic Tablet Vendo Cialis Milano Deutschlnd Drug Buying Doryx <a href=>viagra prescription</a> Prezzo Cialis 10 Mg Farmacia
Updated by RichardPlaic at 2019-06-22 11:21:50
best erectile pump
<a href=>best ed drugs</a>
botox for erectile dysfunction
<a href="">erectile dysfunction treatment</a>
Updated by BernardLAX at 2019-07-25 03:18:48
cyprus viagra
<a href="">sildenafil 100mg price</a>
viagra self life
<a href=>lowest price on viagra</a>
what is using viagra like -
Updated by EllSciego at 2019-08-22 17:53:36
Amoxicillin 500 Mg Side Effects O Trovare Kamagra Economici Comment Durer Longtemps <a href=>cialis 40 mg</a> Online Levitra Cialis Opinion
Updated by LesMoke at 2019-08-26 19:35:30
Amoxicillin Dosage For Kittens <a href=>viagra</a> Precio Proscar Propecia Levitra Prix Orodispersible Cialis Ereccion
Updated by EllSciego at 2019-09-06 07:16:32
Amoxicillin Zpak Buy Gabapentin Online <a href=>levitra samples overnight</a> Buy Cialis In Dubai

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 : *