COPY SHEETS FROM TWO DIFFERENT EXCEL FILES INTO A THIRD

's Computer Specifications

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

's Computer Specifications

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

Hth,
Merjet

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MS Excel Sheets...how to copy and paste one excel sheet into another?	tina SPEILBERG	Microsoft Excel Setup	2	9th May 2008 12:03 AM
How to Copy a sum of a column from different Excel sheets to a single master excel sheet?	Sriram	Microsoft Excel Programming	0	12th Dec 2007 09:38 PM
copy sheets from many files into 1	Steve	Microsoft Excel Programming	1	9th Oct 2007 03:11 AM
Macro to copy sheets from several files into a new workbook.	kiska1970@yahoo.com	Microsoft Excel Programming	2	10th Nov 2005 10:45 PM
MS Excel Sheets...how to copy and paste one excel sheet into another?	tina SPEILBERG	Microsoft Excel Misc	5	4th Aug 2003 09:55 PM