| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create New Workbook - Name book - 4 Sheets - Name Sheets
Greg wrote:
Ok - next time I will play with the code before asking follow up questions. I found that setting a variable to the new workbook name and the running "Kill (name)" seems to work. Are there any issues with that command and format? It's super dangerous if you don't know what you're doing, because it really deletes instead of sending to the recycle bin. It sounds like you know what you're doing, so you should have no problem using it. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I create a quick directory of sheets in workbook | Excel Discussion (Misc queries) | |||
| Macro to create new workbook and sheets | Excel Discussion (Misc queries) | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
| How to create workbook with multiple sheets | Excel Discussion (Misc queries) | |||
| VBA to create an Array of all Sheets in workbook | Excel Programming | |||
![Dick Kusleika[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
