Save under different name

Scruffymessiah

New Member
Joined
Sep 5, 2002
Messages
45
I am trying to find a way of getting excel to automatically save a finished file under a different name. i.e. the same workbook master is used each week with fresh data being added to it by various heads of department, the file is then saved under a different name (usually the department name & then date) and sent for processing by a finance dept. Is there anyway of automating this process so the saved name is uniformed across departments? A lot of these workbooks are used by different departments and this is a way of organising a group of files into a logical order to be processed by finance.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

dullboy

New Member
Joined
Aug 29, 2002
Messages
22
something like this :-

dept = "finance"
dated = Day(Date)
datem = Month(Date)
datey = Year(Date)
fname = dept & dated & datem & datey

Workbooks(2).Worksheets(1).SaveAs Filename:=fname

Workbooks(2).Close
 

Paul B

Well-known Member
Joined
Feb 15, 2002
Messages
575
You could use some Marcos and assign them to buttons so each department could just click on the buttons to save there work, something like

Sub Save_As()
ActiveWorkbook.SaveAs FileName:="C:my documentsdepartment name " & Format(Now, "dd-mmm-yy") & ".xls", FileFormat:= _
xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _
, CreateBackup:=False
End Sub


_________________<FONT SIZE=4 COLOR="red">Paul B</FONT>
Remember To Always Back Up Your Data Before Trying Something New
Using Excel '97
This message was edited by Paul B on 2002-10-22 06:34
 

Forum statistics

Threads
1,143,748
Messages
5,720,625
Members
422,293
Latest member
camillel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top