| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add new workbook with new name
Hi there ,
To add a new workbook with VBA the code is a follows : Workbooks.add This opens a new workbook with the default name book1.xls Is there a way to alter the name when adding a new workbook ? I'd like to add the name through my VBA code when adding a new book. Thanks for any replies MarMo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook | Excel Programming | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
| Copy a range of cells in an unopened workbook and paste it to the current workbook | Excel Programming | |||
| What commands do you use to name a workbook, save a workbook,open a workbook | Excel Programming | |||
Threaded Mode
