Mkdir – path&name from worksheet

[frotaru]

Hello

I want to know if it is possible that a macro can automatically create a folder in a specified location.

For example

Windows("test001.xls").Activate
Sheets("sheet1").Select
Range("A1").Select
ActiveCell.FormulaR1C1 = "c:\test\folderhere"


If I want to create a folder in c:\test with name Folderhere
How can I use Mkdir for range(“A1”)

range(“A1”) will always contain location and name of folder


Than you all

 

[Andrew Poulsom]

Have you tried?

MkDir ActiveCell.Value

or:

MkDir Range("A1").Value

 

[frotaru]

Hi

Yes it worked How simple it was

One more question - how can i put an if Close here

For example the folder name that it will create is "17.10"

If 17.10 exist than make it 18.10
if 18.10 exist than 19.10 and so on ...

something like if xx.10 exist .. than create xx+1.10

Than you

 

[schafers]

Attributes on the Directory?

After adding in the directory, is it possible to change the attributes of that directory? So that the directory is hidden?

I'm trying to make a directory that is a data tab to the file the user has, so I can send updates to this directory without them hosing up the files or directory inside it, as they are just data.

Thanks to the Gurus!!