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