COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD
 

Hi all
I am trying to copy sheet1 from file1.xls and file2.xls into file3.xls which
is empty.
I use vb6 and vb.net
please post some code
I looked in the internet and sheet.copy causes an error!!!
HELP
TIA
Guy

COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD
 

You must specify a particular sheet, e.g. ActiveSheet.Copy or
Sheets(1).Copy or Sheets("Sheet1").Copy.

Hth,
Merjet