Search : in
By :

Comparing two excel sheet in vb 6

Last answer on Apr 8, 2009 12:47:03 pm BST pranali, on Apr 8, 2009 9:51:50 am BST 
 Report this message to moderators

Hello,
i am diploma student and plz plz any one can tell me how to compare two excel sheet in vb 6.0
that means there is 2 excel sheet contaning same data in both the sheet and both the sheet contain 24 thousand columns so i want to compare each feild of one each row with another sheet and if each feild of 1st sheet matches with the 2nd sheet then "yes" otherwise "no" should be display in "result" column which contain in sheet 1

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « comparing two excel sheet in vb 6 » in :
How to freeze a row in an excel sheet ShowHow to freeze a row in an excel sheet To freeze a line in an excel sheet, for example line 1: Select line 2. Go to menu Window and select Freeze panes.
Create an Attendance Report with Excel sheet ShowCreate an Attendance Report with Excel sheet Issue Solution Issue In the case you want to create an attendance report with Excel , here below you will find a nice example: Consider that your report will have the following...
VBA: Finding Hdc in an Excel worksheet or UserForm ShowVBA: Finding Hdc in an Excel worksheet or UserForm Here are two small examples on how to find Hdc in a worksheet: By clicking on Sheet1 the UserForm is displayed. Put the pointer on UF, hold the left mouse button down and drag the...
Multichannel audio (5.1, 6.1, 7.1) ShowMultichannel audio The term "multichannel audio" refers to the use of multiple audio tracks to reconstruct sound on a multi-speaker sound system. Two digits separated by a decimal point (2.1, 5.1, 6.1, 7.1, etc.) are used to classify the various...

1

 setgold57, on Apr 8, 2009 12:47:03 pm BST

Hi,
try this link to get help from Microsoft:
http://support.microsoft.com/kb/213367

Reply to setgold57