software

I need my workbook to save the changes and rename the file (to the name
in cell A1) when I close the workbook ... is it possible to automate
this?

I use the workbook for invoice generation, cell A1 is the unique number
and I have a clerk who keeps overwriting the previous file by simply
answering quot;Yesquot; to the prompt quot;Do you want to save the changesquot; without
renaming the file.

Many thanks for your help

Tony--
y_not
------------------------------------------------------------------------
y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=523844
You should make a master file for your data and always use Save As no
Save. Or you can Save the data to press the key F12 and give a new name
to that file. Hope this will help you.

Dalip--
dalipsinghbisht
------------------------------------------------------------------------
dalipsinghbisht's Profile: www.excelforum.com/member.php...oamp;userid=32557
View this thread: www.excelforum.com/showthread...hreadid=523844
One possibility is to use an auto start macro such as:

Option Explicit
Private Sub workbook_open()
Dim fname As String

fname = Sheets(quot;sheet1quot;).Range(quot;a1quot;).Value

ActiveWorkbook.SaveAs _
Filename:=fname, _
FileFormat:=xlWorkbook, _
Password:=quot;quot;, _
WriteResPassword:=quot;quot;, _
ReadOnlyRecommended:=False, _
CreateBackup:=False
End Sub

This will save the file with the whatever name is in cell A1 every time
it is opened.

Ben--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: www.excelforum.com/member.php...oamp;userid=32097
View this thread: www.excelforum.com/showthread...hreadid=523844