| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving single worksheet
Hello,
I want to save one worksheet of a workbook as a separate xls-file. I use: Worksheets("test").SaveAs "test1.xls". According to the help this should do the job. But everytime the whole workbook is saved, including all other worksheets. How to solve this? Thanks for your answer. Ed van Wijngaarden |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| merging single worksheet files into a single workbook | Excel Discussion (Misc queries) | |||
| Save a single worksheet in Excel as a single file. | New Users to Excel | |||
| Copy from different workbook's worksheet into a single worksheet... | Excel Discussion (Misc queries) | |||
| Converting multiple worksheet to a single page worksheet | Excel Discussion (Misc queries) | |||
| Saving a single cell | Excel Programming | |||
Threaded Mode
