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

adding vlookup into Macro and table_array is different every week. 1
how do i loop thru all the worksheets in 2 files one by one 0
Exporting & Importing with macros 3
Connect Files 4
Macro to copy sheets from several files into a new workbook. 2
Help with copy entire row in a new workbook using a specific value 2
importing files from a directory 2
How to copy and paste multiple files 2

Top