[AccessD] Adding a worksheet to an existing Excel workbook

Hale, Jim jim.hale at fleetpride.com
Tue Jun 10 15:37:46 CDT 2003


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. 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
Jim Hale
-----Original Message-----
From: Barbara Ryan [mailto:BarbaraRyan at cox.net]
Sent: Tuesday, June 10, 2003 2:51 PM
To: Access List
Subject: [AccessD] Adding a worksheet to an existing Excel workbook



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.
 
Thanks,
Barb Ryan

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030610/82634c61/attachment-0001.html>


More information about the AccessD mailing list