| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as saves selected worksheet instead of whole workbook
OK - I figured out what's going on, I think. First of all the line that
says ActiveWorkbook.SaveAs ThisWorkbook.Name - the ThisWorkbook part was the reason it was saving with the words Personal.xls at the beginning. And the reason it's isn't saving all the workbooks is because it's a text file that is just dropped in an Excel doc so it has to be properly saved as an XLS FIRST, then the macro can add the sheets and then it will save the whole thing. Thanks for you help guys |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| save as txt saves different tab, why??? | Excel Discussion (Misc queries) | |||
| save search settings having all tabs selected-or entire workbook | Excel Worksheet Functions | |||
| Excel workbook is corrupted, workbook automatically saves on start | Excel Discussion (Misc queries) | |||
| Save As CSV saves empty rows | Excel Discussion (Misc queries) | |||
| How can I test when any worksheet within a workbook is selected | Excel Programming | |||
Threaded Mode
