Anyway to save just a worksheet in the workbook versus saving the entire workbook? I'm using ActiveWorkbook.save now but I'm only changing a few items in a worksheet - seems kind of inefficient....
Thanks,
Anyway to save just a worksheet in the workbook versus saving the entire workbook? I'm using ActiveWorkbook.save now but I'm only changing a few items in a worksheet - seems kind of inefficient....
Thanks,
The way I understand it, a worksheet is only a part of an Excel document, i.e., workbook,
just as a paragraph or page is only a part of a MS Word document. When you save your work,
the whole document in memory, i.e., the workbook, must be rewritten to disk.
----------------------
Ben
Edit/Move/To new book
"protonLeah" <[email protected]> wrote
in message news:[email protected]...
>
> The way I understand it, a work-sheet- is only a part
> of an Excel document, i.e., work-*book*-,
> just as a paragraph or page is only a part of a MS Word document. When
> you save your work,
> the whole document in memory, i.e., the work-*book*-, must be rewritten
> to disk.
> ----------------------
> Ben
>
>
> --
> protonLeah
> ------------------------------------------------------------------------
> protonLeah's Profile:
http://www.excelforum.com/member.php...o&userid=32097
> View this thread: http://www.excelforum.com/showthread...hreadid=538300
>
Thanks. I think I may try to reorganize it a bit to compartmentalize some of the data that I'm saving for specific purposes into another workbook... this should help with the overhead of the save
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks