Using a variable string in a file save path

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

I cannot seem to use a variable in a save as path name
unless it is the last entry (file name). What is the
syntax for giving a subdirectory in the path a variable
linked to a range?
 
PartPath = "C:\Money Files\Computer Helpers\Modules\"
NextPartPath = Left(ActiveWorkbook.Name, Len(ActiveWorkbook.Name) - 4)
Suffix = Range("A1").Value
FileName = Range("B1").Value

TotalPath = PartPath & NextPartPath & "\" & Suffix & "\" & FileName _
& ".xls"

HTH
Paul
 
Back
Top