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