lesliepear
New Member
- Joined
- Dec 5, 2009
- Messages
- 5
I need VBA code to do the following.
I need to merge 30+ files into 1 file as seperate worksheets using the file name as the sheet name.
I'd also like to compare the similarily named files. The file names are xxx to yyy events dd-mm-yyyy and xxx to yyy history dd-mm-yyy. I want to compare the events and history files with the same xxx and yyy but different dates - I am expecting a 1 row difference between each pair.
Example
USD to CAD history 03-18-2013 to USD to CAD history 03-20-2013
USD to CAD events 03-18-2013 to USD to CAD events 03-20-2013
Code for just the merge would be very helpful. Code for the compare would be even better.
I need to merge 30+ files into 1 file as seperate worksheets using the file name as the sheet name.
I'd also like to compare the similarily named files. The file names are xxx to yyy events dd-mm-yyyy and xxx to yyy history dd-mm-yyy. I want to compare the events and history files with the same xxx and yyy but different dates - I am expecting a 1 row difference between each pair.
Example
USD to CAD history 03-18-2013 to USD to CAD history 03-20-2013
USD to CAD events 03-18-2013 to USD to CAD events 03-20-2013
Code for just the merge would be very helpful. Code for the compare would be even better.