| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
unable to save current workbook within WorkbookBeforeClose
I am trying to save the current workbook within WorkbookBeforeClose, but the workbook is not saving. Is this a bug? And how do I workaround this ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to save current workbook within WorkbookBeforeClose
As always, Post your code
-- Don Guillett SalesAid Software "TTN" wrote in message ... I am trying to save the current workbook within WorkbookBeforeClose, but the workbook is not saving. Is this a bug? And how do I workaround this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to save current workbook within WorkbookBeforeClose
What code are you using?
it should be ThisWorkbook.save -----Original Message----- I am trying to save the current workbook within WorkbookBeforeClose, but the workbook is not saving. Is this a bug? And how do I workaround this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to save current workbook within WorkbookBeforeClose
Try this
Private Sub Workbook_BeforeClose(Cancel As Boolean) ThisWorkbook.Save End Sub -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) www.rondebruin.nl "TTN" wrote in message ... I am trying to save the current workbook within WorkbookBeforeClose, but the workbook is not saving. Is this a bug? And how do I workaround this? ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
unable to save current workbook within WorkbookBeforeClose
The WorkbookBeforeClose is an application level event in my com addi with the following signatur Private Sub Excel_WorkbookBeforeClose(ByVal Wb As Excel.Workbook Cancel As Boolean) Wb.Save End Sub Calling the Wb.Save should save the workbook, but it didn't ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
| save workbook as current date using a macro | Excel Discussion (Misc queries) | |||
| Save Workbook as Current Date/Time | Excel Discussion (Misc queries) | |||
| i made change in a current workbook and accidentally save it, can. | Excel Discussion (Misc queries) | |||
| Handling WorkbookBeforeClose and WorkbookBeforeSave | Excel Programming | |||
Linear Mode
