using string value as part of SaveAs directory path

[29rosemont]

I have a macro to save the summary sheet of a workbook. Is there a way to incorporate a string value as part of the directory path in the SaveAs command?

I trying variations on

Dim Projtype As String
Dim Projname as string
Sheets("Summary&quot.Select
Projtype = Range("C3&quot
Projname = Range("C4&quot
ActiveSheet.saveas Filename:="C:\_Projects\" & Projtype & Projname &".xls",

and other attempts.

The Directory "C:\_Projects\" contains subdirectories matching the projtype value, like 'retail', 'seismic', 'residential', etc.

Either the file is saved with the string 'projtype' as part of the file name, or I error out with a 'Directory path not found'.

Any suggestions?

 

[JPMontreal]

Hi,

You’re missing a
ActiveSheet.saveas Filename:="C:\_Projects\" & Projtype & "\" & Projname &".xls",



Jean-Paul
Montreal
jp@solutionsvba.com
mtljp2@sympatico.ca