I have excel files which have a user form.I open the workbook, as READONLY.The worksheet form opens upon closing the worksheet. It was designed this way so that the user has a choice of where it needs to be saved. The following code prompts the user form to open:
oXl.ActiveWorkbook.Close SavingChanges:=False
when the code executes.
My code pauses; waiting until I manually click CANCEL on the user form or X to close the form in EXCEL.
I've tried UNLOAD me which gives me a 361 run time error.
I need a way to close the workbook without having the form open.