<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1126" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=698153320-10062003><FONT face=Arial color=#0000ff size=2>In an
excel sheet turn the macro recorder on and go edit>move or copy
sheet>check "create a copy">select "new book" from the dropdown menu. Turn
off the recorder. </FONT></SPAN><SPAN class=698153320-10062003><FONT face=Arial
color=#0000ff size=2>The code in the resulting module should give you the basics
of what you need to do to copy your woksheet programatically to an existing
sheet. HTH</FONT></SPAN></DIV>
<DIV><SPAN class=698153320-10062003><FONT face=Arial color=#0000ff size=2>Jim
Hale</FONT></SPAN></DIV>
<DIV><SPAN class=698153320-10062003></SPAN><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Barbara Ryan
[mailto:BarbaraRyan@cox.net]<BR><B>Sent:</B> Tuesday, June 10, 2003 2:51
PM<BR><B>To:</B> Access List<BR><B>Subject:</B> [AccessD] Adding a worksheet to
an existing Excel workbook<BR><BR></DIV></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2>How can I add an Excel spreadsheet (which I
create within an Access 97 app) to an existing Excel workbook? If it
helps, I can setup the Excel workbook to have a pre-defined worksheet that
will accept the spreadsheet from Access.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV><FONT face=Arial size=2>Barb Ryan</FONT></DIV></BLOCKQUOTE></BODY></HTML>