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,

Post the code that is causing the problem.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Matt B" wrote in message
...
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

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


---
Message posted from http://www.ExcelForum.com/

Matt,

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

John

"Matt B" wrote in message
...
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