Hi All,
I'm having three excel files, book1.xls, book2.xls, book3.xls and each having data in sheet1. I want to copy these three sheets to book4.xls as into sheet1, sheet2, sheet3. Please help me. How to code in VB6.
thanks in advance.
regards
ramsri

ramsri

I would open B4, and 1 at a time open B1 — B3.

Create a WorkSheet object, and set it, in turn, to S1 of B1 — B3.

Then use B4’s WorkSheets.Add method to add the current Sheet being held in the WorkSheet object.