asked on

Create a folder thru VBA

Hi: This is the path where folders are created by date. Can any one please tell me if in the upload folder when i save my file and the folder is not exist on todays date then how to i create a new folder with the below format thru VBA code
Thanks.

strPath = "\\usnymel1fs001\new claims\IDT Carmel\upload\" & "PIMS Payment File" & " " & Format(Date, "MMDDYY") & ".xls"

FOLDERS IN UPLOAD DIRECTORY
03-01-07
02-28-07
02-06-07

SOLUTION

Atropa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

rawya

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

jefftwilley

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mustish1

ASKER

It create a folder but next time when i run the program it still goes into the if condition and try to create the folder with todays date and then gives error: Path/File Access Error
If Dir(strPath & Format(Date, "mm-dd-yy")) = "" Then
MkDir strPath & Format(Date, "mm-dd-yy")
End If

SOLUTION