Save and Close Macro

[Steved]

Hello from Steved
Below macro does what I require but when I recorded
this, it works fine, but when I close the file and go
and open another then use the macro it save okay but opens
the origional. Please how can I avoid this. In other words
I want to save the file I am workig on.

Windows 2000 NT
Office 2000

Sub WttSaveClose()
Application.DisplayAlerts = False
ActiveWindow.Close True
Application.DisplayAlerts = True
End Sub

Thanks.

 

[Steved]

Hello From Steved

This is what I've done.

I created a new worksheet then saved it as Personal.xls
to XLStart Folder in Office, Then put the below macro
in and saved it. (works Like a Charm)

Cheers