COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD

  • Thread starter Thread starter Guy Cohen
  • Start date Start date
G

Guy Cohen

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
 
You must specify a particular sheet, e.g. ActiveSheet.Copy or
Sheets(1).Copy or Sheets("Sheet1").Copy.

Hth,
Merjet
 
Back
Top