COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD

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
 
M

merjet

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

Hth,
Merjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to copy sheets from several files into a new workbook. 2
Updating closed excel files 1
I need a VB script for Excel 5
importing files from a directory 2
How to create .pdf dummy files from .xls using batch file 1
How to copy and paste multiple files 2
Help with copy entire row in a new workbook using a specific value 2
copy from dbf and paste to xls 1

Top