I know this Access, but....

[JohnD]

I am trying to make a new directory in Excel with VBA. My code is pasted below.



Public Sub NewFolder()

MkDir "C:\Study"








End Sub

thanks

[PEB]

And when you run this from Vb what appears? Is there any problems?

:)

[JohnD]

A code error box appears, I am doing this from a school computer

[PEB]

What is the error? Maybe the folder exists?