Kirti Arora
New Member
- Joined
- Aug 31, 2017
- Messages
- 1
Hi All,
I have 2 Notepads files having data .I want to merge some of the columns selectively from them to one single notepad. Also, I wanted to merge column values into one and then write that to the output file.
FName,LName,AccountNo,ChasisNo,DrivingLicenseNo,PolicyNo,RegNo1,RegNo2---Columns of 1st notepad
File Size is 10k
Other desired columns are
DOB , SysDate etc. ---These can be taken from file of size 1k(file is basically an existing output file, as these values doesn't change ,so can be copied from there)
The order of the columns of final notepad should be:
FName, LName,DOB, RegNo(merged one),DrivingLicenseNo,PolicyNo,ChasisNo,.etc(size required is 1k)
Can somebody provide some solution for the same. I am very new to VBA.
Thanks in advance.
I have 2 Notepads files having data .I want to merge some of the columns selectively from them to one single notepad. Also, I wanted to merge column values into one and then write that to the output file.
FName,LName,AccountNo,ChasisNo,DrivingLicenseNo,PolicyNo,RegNo1,RegNo2---Columns of 1st notepad
File Size is 10k
Other desired columns are
DOB , SysDate etc. ---These can be taken from file of size 1k(file is basically an existing output file, as these values doesn't change ,so can be copied from there)
The order of the columns of final notepad should be:
FName, LName,DOB, RegNo(merged one),DrivingLicenseNo,PolicyNo,ChasisNo,.etc(size required is 1k)
Can somebody provide some solution for the same. I am very new to VBA.
Thanks in advance.
