opening a file using VBA

[whitey987]

Something that you may help me with im trying to create a user form that will allow me to open folder, the code im using to create the folder is:

MkDir "\\Kenttimber\general\home\Nick\Database\data\" & TextBox1.Value
' creates a new folder in the active folder

but as you can see the folder is not located on my hard drive but on another computer.

Any help you cvan give will be great

 

[Andrew Poulsom]

Do you have a drive mapped to that UNC path?

 

[BrianB]

I do not see anything wrong with your code. Might be easier with a drive mapped to a letter.

I would split it into 2 lines because Excel often has problems trying to do too much at once. Also, it is possible to check the correct string is being passed :-

Dim MyFolderName as String
MyFolderName= _
"\\Kenttimber\general\home\Nick\Database\data\" & TextBox1.Value 
MsgBox(MyFolderName) ' temporary to check
MkDir MyFolderName

 

[whitey987]

how would i then open the folder that has been created??