Every day I have to deal with eight format the same.xls files (each file in about 2 m or so), each.xls files only a worksheet, I want to by vb programming to incorporate the table 1 of the eight.xls files to a new.xls files in table 1, this job can also be realized by vba, of course, but it's just I want to by vb realize the function of the preliminary, I now is in trouble, a lot of code search on the net can't solve my problem, a great god appeared to reassure, thank you!
Contact more than a dozen years ago, self-study vb6, now almost forgotten, want to learn slowly, and at a great god show a thank you, your past

CodePudding user response:

Don't know what's merger, if simply copy together to simple
Workbooks (" book1 "). Sheet1. Range (" a1: a17 "). Copy Workbooks (" book3 ") Sheets (2). The Range (" a1 ")

CodePudding user response:

Using vb to operate excel,

His own operation records to macro, and then in vb implementation can,
If the data gathered is merged, will extract the data, then write a new XLS,