You would use the Add method to create a new worksheet in the active workbook.
xl.Worksheets.Add or xl.Sheets.Add
Darrell
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Thursday, March 05, 2015 2:30 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Working with Excel tabs
I'm using Access 2007 and was wondering if there was a way to use the xl.worksheets() to add tabs on the fly.
I need to create a separate tab for about 10 staff members with a summary tab. Is it possible to add a tab, populate it, and then move to the next tab using VBA on the Access side?
Thanks,
Gary
--------------------------
Binary, easy as 01, 10, 11
The information contained in this communication is highly confidential and is intended solely for the use of the individual(s) to whom this communication is directed. If you are not the intended recipient, you are hereby notified that any viewing, copying, disclosure or distribution of this information is prohibited. Please notify the sender, by electronic mail or telephone, of any unintended receipt and delete the original message without making any copies.
Blue Cross Blue Shield of Michigan and Blue Care Network of Michigan are nonprofit corporations and independent licensees of the Blue Cross and Blue Shield Association.
Posted by: "Embrey, Darrell" <DEmbrey@bcbsm.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar