q: Combine excel files into one sheet.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Combine excel files into one sheet.
I need to write a macro to open all the excel files named as MyFile_200704_*
and insert into a new file Sheet1. How can I do this?
 
Back
Top