|
|
|||||||
|
|
Thread Tools | Display Modes |
|
#2
06-18-2012, 04:58 PM
|
||||
|
||||
Your macro is only saving the worksheet, not the workbook. You should delete the unwanted worksheets, then save the remaining workbook with the new name.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| excel 2010, macro, save as |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Range(Cell1,Cell2) Error on another workbook controlling some other workbook? | tinfanide | Excel Programming | 1 | 02-09-2012 04:08 PM |
| Cutting and Pasting and Macro problems in Excel 2010 | enkel | Excel Programming | 3 | 01-02-2012 10:15 PM |
| Mail with macro Excel 2010 | santors71 | Excel Programming | 1 | 12-07-2011 06:34 AM |
| How do I assign a macro to a button when the macro is in my personal workbook? | foolios | Excel Programming | 2 | 07-27-2011 02:41 PM |
 macro to transfer data from one workbook to another workbook
|
virsojour | Excel Programming | 5 | 02-01-2011 08:58 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode