Save As

  • Thread starter Thread starter carloshernandezy
  • Start date Start date
C

carloshernandezy

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
 
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
 
ActiveWorkbook.SaveAs "C:\.....\" & Range("DW1").Value & "\" & _
"AchiveName-Resume" & Range("DW2").Value & ".xls"

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

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
 
Back
Top