AFGPHXExcel
asked on
How to make a new Directory?
I am trying to create a new folder and I am getting a run-time errror 76: Path not found.
RCOTSaveLoc = "c:\LogcapRequests\" & [c_NameGen_PPR].Value & "\"
If Len(Dir(RCOTSaveLoc, vbDirectory)) = 0 Then
MkDir RCOTSaveLoc
End If
Also, RCOTSaveLOC= "c:\LogcapRequests\FLR-11-
RCOTSaveLoc = "c:\LogcapRequests\" & [c_NameGen_PPR].Value & "\"
If Len(Dir(RCOTSaveLoc, vbDirectory)) = 0 Then
MkDir RCOTSaveLoc
End If
Also, RCOTSaveLOC= "c:\LogcapRequests\FLR-11-
Last Comment
ASKER
No it does not.
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks. I found out that I had to create the Logcaprequests with Mkdir and then c:\LogcapRequests\FLR-11-0
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
Does FLR-11-0005-CJ05-228-14321
Ed