Naming a variable in a file path
 

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?

Naming a variable in a file path
 

mkdir "C:\My documents\ & Range("A1").Value

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

--
regards,
Tom Ogilvy

Ron wrote in message
...
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?