Using a variable string in a file save path
 

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?

Using a variable string in a file save path
 

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
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
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?