Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Saving
i've created a macro such that when a user saves, it will copy th
contents in the workbook that needs to be saved into an excel fil located on a server. this works fine and all but what i would like t be able to do is to stop excel from saving the current workbook becaus this workbook is huge and i don't want the user to wait for th workbook everytime he hits the save button. one more question, is there an event for the autosave? i'd like to hav auto save also save to the excel file on the server. last question. how could i save the contents of a text box to anothe file without having to save the entire textbox? thanks in advance for your hel -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Saving
Hi majikman ,
Excel provides a BeforeSave event that you can use to cancel the save if you'd like: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) If Not SaveAsUI Then Cancel = True End Sub This example will only cancel the save if the Save As dialog is not going to be shown (ie, the user hits save or selects File | Save). If you want to block all saves of the workbook, then you'd just use Cancel = True. -- Regards, Jake Marx MS MVP - Excel www.longhead.com [please keep replies in the newsgroup - email address unmonitored] i've created a macro such that when a user saves, it will copy the contents in the workbook that needs to be saved into an excel file located on a server. this works fine and all but what i would like to be able to do is to stop excel from saving the current workbook because this workbook is huge and i don't want the user to wait for the workbook everytime he hits the save button. one more question, is there an event for the autosave? i'd like to have auto save also save to the excel file on the server. last question. how could i save the contents of a text box to another file without having to save the entire textbox? thanks in advance for your help |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop Saving
Hi
put the following code in your workbook module: Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) Cancel = True End Sub -- Regards Frank Kabel Frankfurt, Germany "majikman " schrieb im Newsbeitrag ... i've created a macro such that when a user saves, it will copy the contents in the workbook that needs to be saved into an excel file located on a server. this works fine and all but what i would like to be able to do is to stop excel from saving the current workbook because this workbook is huge and i don't want the user to wait for the workbook everytime he hits the save button. one more question, is there an event for the autosave? i'd like to have auto save also save to the excel file on the server. last question. how could i save the contents of a text box to another file without having to save the entire textbox? thanks in advance for your help --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop someone saving a web downloaded workbook? | Excel Discussion (Misc queries) | |||
Why does Excel 2007 stop responding after saving | Excel Discussion (Misc queries) | |||
My hyperlinks stop working on saving the workbook | Excel Discussion (Misc queries) | |||
How do I stop Excel from saving a file with a different name? | Excel Discussion (Misc queries) | |||
how do I stop warnings when saving .xls as csv? | Excel Discussion (Misc queries) |