Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible?
i have a workbook with 4 sheets on it. is it possible to save just one of the
sheets throughout the day while keeping the workbook open. when the workbook closes the whole workbook to save? just to speed up the saving time. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible?
Hi
AFAIK this is not possible -- Regards Frank Kabel Frankfurt, Germany "choice" schrieb im Newsbeitrag ... i have a workbook with 4 sheets on it. is it possible to save just one of the sheets throughout the day while keeping the workbook open. when the workbook closes the whole workbook to save? just to speed up the saving time. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible?
"choice" wrote in message
... i have a workbook with 4 sheets on it. is it possible to save just one of the sheets throughout the day while keeping the workbook open. when the workbook closes the whole workbook to save? just to speed up the saving time. If I understood you correctly: Move that sheet to its own temporary workbook, save that workbook, at the end of the day when you want to save the whole workbook, move the worksheet back, delete the temporary workbook and save the main one. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
is this possible?
Look at Chip Pearson's page on using application.OnTime
http://www.cpearson.com/excel/ontime.htm in the macro, you would do something similar to what Ian suggests Workbooks("MyData.xls").Worksheets("sheet3").copy 'creates copy in new workbook Application.Displayalerts=False Activeworkbook.SaveAs "C:\TempDir\MyData1.xls" Application.DisplayAlerts = True Activeworkbook.Close Savechanges:=False This retains the sheet in the original workbook, but makes a copy of it and saves it and then closes this additional workbook. -- Regards, Tom Ogilvy "choice" wrote in message ... i have a workbook with 4 sheets on it. is it possible to save just one of the sheets throughout the day while keeping the workbook open. when the workbook closes the whole workbook to save? just to speed up the saving time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|