ThisWorkbook.Close SaveAs:=false

[aamir90w]

Hi,
I am using Workbook1. And from Workbook1 i open Workbook2 in read only mode "workbooks.open("Workbook2"), readonly = true
because i am using workbook2 only for read purposes, i dont want to save it. but excel gives me warning to save the workbook.

I have tried to put this command in workbook2 "ThisWorkbook.Close Save:= false" in beforeclose function. But after that command exectued excel crashed!

Help please!

 

[JLGWhiz]

If you are running code from Workbook1, then that would be 'ThisWorkbook' and using the command

ThisWorkbook.Close False

Would close Workbook1, terminating your code. So Excel is not necessarily crashing, it is probably just closing the host workbook. If you used

Workbooks(2).Close False

it might work better.

 

[aamir90w]

If you are running code from Workbook1, then that would be 'ThisWorkbook' and using the command

ThisWorkbook.Close False

Would close Workbook1, terminating your code. So Excel is not necessarily crashing, it is probably just closing the host workbook. If you used

Workbooks(2).Close False

it might work better.

No, I close workbook2 just normal way with x from top right corner, and in workbook2 i have written a code in beforeclose action "ThisWorkbook.Close false"

 

[JLGWhiz]

Try adding this line in your before close macro, before the 'ThisWorkbook.Close False' statement.

ThisWorkbook.Saved = True

and see if that solves the problem. You basically lie to the compiler by setting the saved trigger.