| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MkDir error
Can anyone tell me if this is correct? I get a 76 - Path
not found error when I try to see if a directory exists. I can navigate to it. If Len(Dir("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date), vbDirectory)) = 0 Then MkDir ("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date)) Thanks, Eric |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MkDir error
Hi
try preceding this statement with ChDir "J:" -- Regards Frank Kabel Frankfurt, Germany Eric wrote: Can anyone tell me if this is correct? I get a 76 - Path not found error when I try to see if a directory exists. I can navigate to it. If Len(Dir("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date), vbDirectory)) = 0 Then MkDir ("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date)) Thanks, Eric |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MkDir error
Should HIPSLids have a \ after it?
-- Regards, Tom Ogilvy "Eric" wrote in message ... Can anyone tell me if this is correct? I get a 76 - Path not found error when I try to see if a directory exists. I can navigate to it. If Len(Dir("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date), vbDirectory)) = 0 Then MkDir ("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date)) Thanks, Eric |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
MkDir error
That's what it was. Thanks.
-----Original Message----- Should HIPSLids have a \ after it? -- Regards, Tom Ogilvy "Eric" wrote in message ... Can anyone tell me if this is correct? I get a 76 - Path not found error when I try to see if a directory exists. I can navigate to it. If Len(Dir("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date), vbDirectory)) = 0 Then MkDir ("J:\QA\MonthlyProductAnalysis\HIPSLids" & strplant & "\" & Year(Date)) Thanks, Eric . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
| mkdir command in excel 2003 on XP SP2 | New Users to Excel | |||
| Code Error - Run Time Error 5 (Disable Cut, Copy & Paste) | Excel Programming | |||
Linear Mode
