I have the following macro formula -

End With
ActiveWorkbook.Close False
End Sub

Which is closing the workbook down
Can someone tell me how i need to change it so it saves in its own nam
automatically when it closes.

thanks

legep

--
legep
-----------------------------------------------------------------------
legepe's Profile: http://www.excelforum.com/member.php...fo&userid=1548
View this thread: http://www.excelforum.com/showthread.php?threadid=27190

Hi
activeworkbook.save

--
Regards
Frank Kabel
Frankfurt, Germany

"legepe" schrieb im Newsbeitrag
...

I have the following macro formula -

End With
ActiveWorkbook.Close False
End Sub

Which is closing the workbook down
Can someone tell me how i need to change it so it saves in its own
name
automatically when it closes.

thanks

legepe


--
legepe
---------------------------------------------------------------------
---
legepe's Profile:
http://www.excelforum.com/member.php...o&userid=15485
View this thread:
http://www.excelforum.com/showthread...hreadid=271905