Auto workbook create

[Rahulwork]

Hi Everyone,

i have a code which create workbook into the specific folder. however i want to create multiple folder by the date name:

for example

code is

ActiveWorkbook.SaveCopyAs "D:\TEMP\XXXX.XLS"

so i want, this XXXX file name should depend on A1. where we would have date. so i can create multiple copy of current work with the date bifurcation

 

[Fluff]

How about

"D:\TEMP\" & Format(Range("A1").Value, "dd-mm-yyyy") & ".XLS"

 

[Rahulwork]

thanks i would check and seems it would work too

by the way fluff, is there any chance if i can add a code in above that

i want to hide a specific sheet in copy one. like this button would be on sheet name "East" so when i create copy that sheet should be hidden. possible?

 

[Fluff]

Is the code in the sheet module of sheet "East"?

 

[Rahulwork]

no code is on the button placed on east sheet.

 

[Fluff]

In that case I don't understand what you are asking.

 

[Rahulwork]

I have a button to create a new workbook. the one which i asked initially.

Under the new workbook there is a sheet by the name of East. I want that sheet should be hidden

 

[Fluff]

Do you always want to hide the "East"?

 

[Rahulwork]

Yes.it should nt be visible. Till the tym smone unhide it

 

[Fluff]

In that case add this line, before the saveas line

Sheets("East").Visible = xlSheetHidden