View Full Version : Mkdir
CicoMico
08-31-2007, 01:31 AM
Hello!
can somebody explain to me, why I am getting error on this (path not found):
MkDir Environ("HOMEPATH") + "try"
msgbox shows it correctly...
Thank you
Bob Phillips
08-31-2007, 01:44 AM
Should it be
MkDir Environ("HOMEPATH") & Application.PathSeparator & "try"
CicoMico
08-31-2007, 01:51 AM
Should it be
MkDir Environ("HOMEPATH") & Application.PathSeparator & "try"
hmm... i already tried that... still doesn't work...
Bob Phillips
08-31-2007, 02:37 AM
What does MkDir Environ("HOMEPATH") alone give you?
CicoMico
08-31-2007, 03:27 AM
What does MkDir Environ("HOMEPATH") alone give you?
path not found
Bob Phillips
08-31-2007, 03:29 AM
So that suggest that you don't have such a variable set up does it not, so you cannot use it.
Bob Phillips
08-31-2007, 03:33 AM
How about trying this
MkDir CreateObject("WScript.Shell").SpecialFolders(16) & application.PathSeparator & "try"
I think you need:
MkDir Environ("HOMEDRIVE") & Environ("HOMEPATH") & Application.PathSeparator & "try"
CicoMico
08-31-2007, 05:15 AM
thanx to all! it is working now!
mdmackillop
09-01-2007, 02:13 AM
"USERPROFILE" works for me.
For a listing, try
Sub MyEnvirons()
For i = 1 To 100
Cells(i, 1) = Environ(i)
Next
End Sub
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.