Copy Sheet from One workbook to another EXISTING workbook

[Ken Soenen]

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

[Jim Cone]

ken,
Workbooks("FirstBook.xls").Worksheets("Sheet1").Copy _
after:=Workbooks("SecondBook.xls").Worksheets("Sheet3")
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Ken Soenen" <ksoenen@trip.net>
wrote in message
news:11ut7hb8qhoe7b4@corp.supernews.com...
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

[Ken Soenen]

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

"Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
news:%23DgpUU4LGHA.676@TK2MSFTNGP10.phx.gbl...
> ken,
> Workbooks("FirstBook.xls").Worksheets("Sheet1").Copy _
> after:=Workbooks("SecondBook.xls").Worksheets("Sheet3")
> Jim Cone
> San Francisco, USA
> http://www.realezsites.com/bus/primitivesoftware
>
>
> "Ken Soenen" <ksoenen@trip.net>
> wrote in message
> news:11ut7hb8qhoe7b4@corp.supernews.com...
> 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
>
>