Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Path Not Found Error
Hello my firends,
I'm trying to do what seems to me to be a verysimple thing. use MkDir to create a directory. my code looks like this: Dim PathName as String PathName=Sheets("sheet1").range("a1") ' this cell contains C:\App\data\ as the string MkDir PathName .... when i run it i get a Path Not Found error. but when i run the following it's fine; MkDir Thisworkbook.Path & "\" & PathName Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Program.xls cannot be found error | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
error "module not found" | Excel Discussion (Misc queries) | |||
Which Path not found? | Excel Programming | |||
Error Msg: 'No Cells were found' | Excel Programming |