close workbook method

[pm]

is it safe to use this?
When I use it my program crashes, however if I run it in debug mode it works..To debug I put 2 print statements, one before the close method and one after the close method..it just sits on the close method and does not print my second debug line..
I am stumped!
I have 2 workbooks open at the time..and I have to close the one that is active
I used Activeworkbook.close

please help
tia

[bergy]

On 2002-05-10 14:12, pm wrote:
is it safe to use this?
When I use it my program crashes, however if I run it in debug mode it works..To debug I put 2 print statements, one before the close method and one after the close method..it just sits on the close method and does not print my second debug line..
I am stumped!
I have 2 workbooks open at the time..and I have to close the one that is active
I used Activeworkbook.close

please help
tia

Could you be hanging up on a DisplayAlert asking you if you want to save? Try adding the following lines around the ActiveWorkBook.Close line and see if it works:

Application.DisplayAlerts = False
ActiveWorkbook.Close 'this is your line
Application.DisplayAlerts = True

[NateO]

Or add a word, should close w/o save either way:

ActiveWorkbook.Close False

_________________
Cheers, NateO

[ This Message was edited by: NateO on 2002-05-10 14:34 ]