Hi Barb,

Thank you for the tip. It's very helpful and much appreciated.

Kind regards,

Polar

Barb Reinhardt;430685 Wrote:
If I just want to close a workbook, instead of using this


Code:
--------------------

Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = True

--------------------

I use this

Code:
--------------------
ActiveWorkbook.Close SaveChanges:=False
--------------------


HTH,
Barb Reinhardt

"polar" wrote:


Hi Simon and OssieMac,

Thank you for your responses.

The error message I was getting was:

"Application-time error 1004

Save as Object Failed"

This has now gone. The code you provided me with OssieMac works
very
well.

Thank you again Simon and OssieMac for your help.

Kind regards,

Polar


--
polar

------------------------------------------------------------------------
polar's Profile: 'The Code Cage Forums - View Profile: polar'
(http://www.thecodecage.com/forumz/member.php?userid=564)
View this thread: ''Save As' Macro Debug Error - The Code Cage
Forums' (http://www.thecodecage.com/forumz/sh...d.php?t=119605)




--
polar
------------------------------------------------------------------------
polar's Profile: http://www.thecodecage.com/forumz/member.php?userid=564
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119605