Fill listbox with Array of folders

(Modifying some code by Leith Ross) I am stumbling why I get an error trying to fill the listbox with folder names. (See code in red for error location)

Run time 'error' 53:
File not found

If I ommit "& sCustomer" it works? I want the list from sCustomer. Which is just a list of sub folders.

Please Login or Register  to view this content.

The path sFolderPath exists as shown, sCustomer is selected from an optionbutton and is hardcoded so that name exists as well.

Any hints, tips or examples are welcome.

I have doubled up on the last folder name in my path string....Now to figure out why.

Does sCustomer have a backslash on the end of it?

No, it is a folder name only such as:
Example

Please Login or Register  to view this content.

The folder tree is:
F:\CNC Mill\#19 CNC CMM\Inspection Reports\"
then sCustomer which is;
"Test"
Then some sub folders.

The sub folders are my target.

I thought that this section of code:

Please Login or Register  to view this content.

Would begin the first name of the subfolders from sCustomer, it doesnt, it begins with sCustomer itself.
Thus I am getting a target path of:

F:\CNC Mill\#19 CNC CMM\Inspection Reports\TestTest"

An invalid name.

If I remove "& sFolderName" from:

Please Login or Register  to view this content.

Then I get a single entry in the listbox as "Test".

If sCustomer does not end in a backslash, then this:

Please Login or Register  to view this content.

needs to be this:

Please Login or Register  to view this content.

which is what I was hinting at...

I believe I tried that and it resulted in

F:\CNC Mill\#19 CNC CMM\Inspection Reports\Test\Test

Still invalid.

If I change to this:

Please Login or Register  to view this content.

I get the same thing!?

I may be lost. LOL
sigh...

{head scratch}

Try this:

Please Login or Register  to view this content.

That was it? All the code needed was "& "\""a the end of:

Please Login or Register  to view this content.

[Palm to forehead]
Smack!
[/Palm to forehead]

I looked at every angle but that.
Thanks for the help!
Im sorry I am not allowed to add to your rep, we are limited some how.

Yep - otherwise the Dir looks for that folder name, not in that folder.

Originally Posted by romperstomper

Yep - otherwise the Dir looks for that folder name, not in that folder.

Some how, I missed that part.