here is the code:
Code:
Option Explicit Dim miMaxColumns As Integer Sub CompareSheets() Dim bChanged As Boolean, baChanged()
aldusarugay
Last Activity: Jun 26 '14, 08:32 AM
Joined: Jun 13 '14
Location:
-
Convert excel vba to vb.net
hi good day to all, i have this code to compare two excel sheets and show their differences in the 3rd sheet but the code is in vba format and i want to convert this to vb.net. i am asking for help regarding this problem. im new here and i appreciate your help thank you.
here is the code:
... -
hi again actually what im trying to do is to consolidate the difference in the 3rd sheet.
for example:
in the cells 3rd sheet it shows,
Added - present in sheet 2 but not in sheet 1
Deleted - present in sheet 1 but not in sheet 2
Changed - there is value on same cell in both sheet but the values are different -
good day Luk3r. i will try to do what you are suggesting. thank you. i'll get back to you if there any progress on my code.Leave a comment:
-
Compare 2 excel worksheet, consolidate differences in 3rd sheet
Hi All,
I would like some help regarding my code. I want a function that compares 2 excel sheets in a workbook and consolidate their differences in the 3rd sheet. Right now my code can compare the 2 sheets and highlight their differences. All i want in the 3rd sheet is to show what are the changes, e.g (added data, deleted data, changed data). Thanks in advance for helping me :D Here is my code :
...Code:Dim xlApp As New Excel.Application
No activity results to display
Leave a comment: