Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically close form before closing
I am using vba to open an xl file, make changes, and then close it. To
automatically save the changes, I used: WB.Close savechanges:=True The problem is that a form pops up with a Workbook_BeforeClose sub (like a splash screen). I need to close that form before the savechanges dialog. The form is called frmEndBox, and the button to close it is cmdSubmit. I need something like WB.Close [frmEndBox.cmdSubmit.Value=True] savechanges:=True Hopefully someone can help with this. Thanks, ~ Horatio |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
close workbooks without closing excel ? | Excel Discussion (Misc queries) | |||
How do I close excell worksheet without closing others still open | Excel Worksheet Functions | |||
close workbook without closing excel and stop recursive function | Excel Discussion (Misc queries) | |||
Cant get a combo box to update without closing form | Excel Discussion (Misc queries) | |||
Closing a Form | Excel Discussion (Misc queries) |