sathyamoorthi
asked on
Manipulating Excel object using VB
I will be getting an XML file from one application and i need to compare the data in that XML file with the data i get from another one application in Excel format. i can view the XML file in excel format, but my problem is the order in which the columns are arranged is different in both the files.
for example,
order of columns in first excel sheet:
A
B
C
D
E
order of columns in second excel sheet:
E
A
C
B
D
if i can column order is same in both the excel sheets, it will be easy for me to compare data in that.
How can i change the column order in one excel sheet to resemble the other one using VB code?
for example,
order of columns in first excel sheet:
A
B
C
D
E
order of columns in second excel sheet:
E
A
C
B
D
if i can column order is same in both the excel sheets, it will be easy for me to compare data in that.
How can i change the column order in one excel sheet to resemble the other one using VB code?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I will leave a recommendation in the Cleanup topic area that this question is:
- Points for harris_c
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
Venabili
EE Cleanup Volunteer