Save As
 

Hello to all,

I´m triying to save a file in variable directory and with a variable
name.

C:\.....\year\weekXX

Archive Name- ResumeWeekXX.xls

-year- is the value of a cell in worksheet DW1
-weekXX- is the value of a cell in worksheet DW1

Thanks for your help

Save As
 

Hi

I would declare some variables, set each variable to thbe value of one of
the referenced cell adresses, and then concatanate it,

Dim varDir, varYear, varWeek as String

varDir = "C:\ and your directory.....\"
varYear = cell address
varWeek = Cell address

Worksheet.SaveAs filename:= varDir & varYear & "\" & varWeek
"carloshernandezy" wrote:

Hello to all,

I´m triying to save a file in variable directory and with a variable
name.

C:\.....\year\weekXX

Archive Name- ResumeWeekXX.xls

-year- is the value of a cell in worksheet DW1
-weekXX- is the value of a cell in worksheet DW1

Thanks for your help

Save As
 

ActiveWorkbook.SaveAs "C:\.....\" & Range("DW1").Value & "\" & _
"AchiveName-Resume" & Range("DW2").Value & ".xls"

fill in the .....
--
Regards,
Tom Ogilvy

"carloshernandezy" wrote in message
oups.com...
Hello to all,

I´m triying to save a file in variable directory and with a variable
name.

C:\.....\year\weekXX

Archive Name- ResumeWeekXX.xls

-year- is the value of a cell in worksheet DW1
-weekXX- is the value of a cell in worksheet DW1

Thanks for your help

Save As
 

Thanks to all