Using a variable string in a file save path

[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?

 

[pfsardella]

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