Create New Workbook and copy sheets from my Speadsheet

Posted to microsoft.public.excel.programming

Jeffrey[_2_] Jeffrey[_2_] is offline

external usenet poster

Posts: 14

Create New Workbook and copy sheets from my Speadsheet

Hi All,

Good day. My situation is this, I have a spreadsheet. I need a code
which will create a new workbook and copy the Sheets("Quotation") and
Sheets("ClientQuotation") from my spreadsheet to this new workbook.
The code also needs to rename my new workbook with the same name as my
spreadsheet but with added "-Client". For example my spreadsheet
filename is "qt Auck 1234", then the new workbook should have a name
"qt Auck 1234-Client".

Please advice from anyone.

Cheers.

Jeff

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA	Amaxwell	Excel Worksheet Functions	4	August 17th 06 06:23 AM
Create New WB with copy of Sheets 1 & 2 when sheets count reaches 100	Corey	Excel Programming	5	June 26th 06 04:52 AM
Create new workbook, temporarily name it and copy sheets to it	DerbyJim	Excel Programming	4	January 12th 06 05:03 PM
create workbook, copy sheets	Pierre via OfficeKB.com[_2_]	Excel Programming	0	October 25th 05 07:51 AM
Create New Workbook - Name book - 4 Sheets - Name Sheets	Greg[_21_]	Excel Programming	6	June 12th 05 04:41 AM

All times are GMT +1. The time now is 11:21 PM.

Menu

About Us