VBA Convert to Binary Format And Consolidated Sheet Data

[unknownymous]

Hi Guys,

Just wanted to ask if you could help me out on this.

I have excel file with file name Monthlies xxxx on .xls format. Note that xxxx = date which changes every month. The file has 6 Tabs (Sheet 1-6). I need to convert the file first in binary then consolidated Sheet 1-5 on Sheet 1 as it normally consists of 300K lines when combined. So Sheet 1 and Sheet 6 will be retained.


Any help will be much appreciated

Thank you!