| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
After Workbook.Add
I use the following macro I created with the macro recorder to add a new
workbook without vb code for emailing. What I need to know is how to give a name to this workbook after it is created. Help would be appreciated. Workbooks.Add Windows("Form 200").Activate Sheets(Array("Cus Futures", "House Futures", "Cus Calls", "Cus Puts", _ "House Options", "Cus Indexes")).Select Sheets("Cus Futures").Activate Sheets(Array("Cus Futures", "House Futures", "Cus Calls", "Cus Puts", _ "House Options", "Cus Indexes")).Copy Befo=Workbooks("Book2").Sheets(1) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding a chart to large workbook brings workbook activity to a hal | Excel Discussion (Misc queries) | |||
| Macro to copy an image (or picture) from one workbook to a new sheetin another workbook | Excel Worksheet Functions | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
| Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
Threaded Mode
