Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Here's my code:
UNITFOLDER = "G:\A F S\Monthly Reports\HiPath\CS\" FILENAME = "MONTHLYC_" NEWDIRECTORY = UNITFOLDER & RPTRUNDATE If Dir(UNITFOLDER & RPTRUNDATE) = Null Then MkDir (NEWDIRECTORY) End If Not sure why it's not working. It won't create the folder and I get an error later. RPTRUNDATE is a variable (string) set earlier that in my example I'm using "060206" as the string. I want it to first check if "G:\A F S\Monthly Reports\HiPath\CS\060206" exists. If it doesn't, I want it to create the folder. If it does exist, just keep going (earlier in the code I delete any files in the directory). Anyone have any idea why it's not working? THX |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
mkdir command in excel 2003 on XP SP2 | New Users to Excel | |||
MkDir and Save As | Excel Programming | |||
mkdir problem | Excel Programming | |||
mkdir problem | Excel Programming | |||
MkDir error | Excel Programming |