macro to check if folder exist and if not create it

[tonywatsonhelp]

Hi everyone,
I need a macro that can create a folder in the "My Documents" folder of the computer its being run on without knowing the path.
the excel document the macro is being run on will be held in sharepoint and opened so i'm a bit confused as to how to refer to the computer its being run on?
please help if you can
Thanks
Tony

 

[6StringJazzer]

How are you opening the file--in the browser version of Excel, or on an installed desktop version? The two versions use two different macro languages.

In VBA:

On Error Resume Next
MkDir Environ("USERPROFILE") & "\My Documents"
On Error GoTo 0

 

[tonywatsonhelp]

It will be run on an installed desktop version

 

[6StringJazzer]

So VBA is the answer. See above code. If you have no VBA experience I will have to give more detailed instructions, and also ask you what action you want to trigger running the macro.

 

[tonywatsonhelp]

Hi Jeff,
thats all i needed thank you Tony