mkdr

  • Thread starter Thread starter mudraker
  • Start date Start date
M

mudraker

sounds like your entry in fname does not include a full path


You need to include full path or change to the drive & folder where the
sub folder is to be created


My formula entered into cell named fName
="c:\Temp\"&TEXT(TODAY(),"yy-mm-dd")


Sub MakeDir()
Dim fPath As String

' may need place change directory code here

fPath$ = Range("fName").Value
If Dir(fPath, vbDirectory) = "" Then
MkDir (fPath)
End If
End Sub
 
Hi,

Im having problems using the mkdir command in my macro. I want to make the
directory specidied in a cell (as the path changes dependant upon date
etc..)

I have set the value of this cell to "fname" in my macro, and have used "if
fname doesnt exist then mkdir fname (obviously in code).

This has the effect of creating a directory "fname" in the last directory I
had open, not the directory specified in the cell.

Could this be anything to do with the fact that the cell with the path is
actually a formula?

Hope this makes sense!

TIA

Matt
 
Matt,

Check your PC time settings too.
They're off by about 8 hours.
Maybe your time zone is set wrong.

John
 
Back
Top