ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Stop Saving (https://www.excelbanter.com/excel-programming/298360-stop-saving.html)

majikman[_20_]

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


Jake Marx[_3_]

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



Frank Kabel

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/




All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com