Thanks Jim . Tried it and it looks like it does exactly what I'm looking
for.
ken

"Jim Cone" wrote in message
...
ken,
Workbooks("FirstBook.xls").Worksheets("Sheet1").Co py _
after:=Workbooks("SecondBook.xls").Worksheets("She et3")
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Ken Soenen"
wrote in message
...
Does anybody know a way to copy a WorkSheet (in Visual Basic) from one
WorkBook to another EXISTING Workbook. Using comma delimited files doesn't
work because the formatting of the sheet isn't copied. I also tried the
export/import of an xls file (via VB) and it not only didn't copy the
formatting, it didn't copy all the data(which was all values).
thanks,
ken