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