Dir Help

[bishoposiris]

I have the following code:

Please Login or Register  to view this content.

FilesInPath is always showing empty for some reason. Am I using Dir wrong? I'm always getting:

Please Login or Register  to view this content.

What I want is the path to the files. For example, if i = 3 then FilesInPath should look like this:

Please Login or Register  to view this content.

What am I doing wrong?

[Phil_V]

What I want is the path to the files. For example, if i = 3 then FilesInPath should look like this:

Please Login or Register  to view this content.

You have missed a path delimiter in your code then.
Your existing code;

Please Login or Register  to view this content.

Would give you: X:\C&A Analysts Team\PF Process\1 Tally & PF's Work in Progress\Centers\VCollinsville*.xl*

You need to change your code line to be:

Please Login or Register  to view this content.

Hope that helps

[bishoposiris]

That was it! Thanks for your help.