Naming a variable in a file path

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

Ron

I am trying to name a directory in a Save As path by using
a reference to a range for a directory name. This works
fine for creating a file name but not the directory part
of the path. Any suggestions?
 
mkdir "C:\My documents\ & Range("A1").Value

If you create a valid argument that would work with mkdir, you shouldn't
have a problem.
 
Back
Top