Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open CommandBar corrupt excel files
Hi,
I have 2 macros that create and delete a custom command bar at the opening and before close. A) When I save the file and then click on "X" without saving, I can reopen the file. B)But when I save the file, click on "X" and click on save, I can't reopen the file (Excel ask to recover the file). Does anyone have an idea? Thank you! Alex Private Sub Workbook_Open() Call CreateCommandBar End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Call DeleteCommandBar End Sub -- Alex St-Pierre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook_Open CommandBar corrupt excel files
I think it's coincidence.
Try creating a test workbook with the same routines and save that. I bet it works ok. I'm betting that your workbook is corrupted--or on the cusp of being corrupt. Alex St-Pierre wrote: Hi, I have 2 macros that create and delete a custom command bar at the opening and before close. A) When I save the file and then click on "X" without saving, I can reopen the file. B)But when I save the file, click on "X" and click on save, I can't reopen the file (Excel ask to recover the file). Does anyone have an idea? Thank you! Alex Private Sub Workbook_Open() Call CreateCommandBar End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Call DeleteCommandBar End Sub -- Alex St-Pierre -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Corrupt Excel files when saving to Win2k3 server | Excel Programming | |||
Programmatically determining corrupt excel files | Excel Discussion (Misc queries) | |||
Keep saving corrupt Excel files | Excel Discussion (Misc queries) | |||
corrupt Excel 2000/2002 files | Excel Discussion (Misc queries) | |||
Excel 2000 - Files corrupt after saving via VBA | Excel Programming |