Directory checking and creation

[MisterPan]

Hi all,

Having a bit of trouble with a line of code I'm trying to write. Basically I want it to check if a directory on the server exists, and if it doesn't, create that folder. That part works fine. The problem I'm having now is with the next check on the sub-directory.

The first line of code I have is:

Please Login or Register  to view this content.

... and that works fine. The next line always gives me a "Compile Error: Expected: expression":

Please Login or Register  to view this content.

I'm fairly sure it's how I'm trying to include the sub-directory with the backslash after the first "yyyy"), but I can't find a way to do it! In plain English, it needs to look for\Debt Reports\Dispute Reports YEAR\MON YEAR and then another sub-directory check after that one. If someone can help me with the above I know I can do the rest, just stuck on this one bit!

Many thanks for any and all suggestions!

Peter

[Norie]

Are you trying to include the mmm yyy in the path/folder you are checking?

Please Login or Register  to view this content.

[MisterPan]

Hi Norie,

That's correct. So if I wanted to run it today, I would expect it to be looking for:

\\ukuxhqfs01\dispute$\Debt Reports\Disputes Reports 2014\Nov 2014

Thanks,

Peter

[MisterPan]

Hi Norie,

That worked beautifully! Thank you!

Can't believe I missed out the extra ampersand and quotes!