Can't open another Workbook with VBA Excel

All,

I'm trying to open and import x cells from another Workbook with help of a Macro (assign to a command button).
However, I can't get it to work. I can't open the Workbook itself. I get an error 400.

Below the code

Please Login or Register  to view this content.

As you can see, I am already "looking" for all the available files in a certain folder, and when 1 is chosen, the filepath and filename is being collected.
And I want to open this same workbook/sheet to get a few cells their value. I can't get it to open the workbook. (and no I didn't code in which cells yet, as I want to see if I can get it to work first).

Any help would be appreciated.

Thank you

-=CWever=-

Originally Posted by rorya

You didn't answer my question.

Ok, there is no value when the code fail.

Originally Posted by bakerman2

FolderName does not reflect the dir you have chosen to list the files from.

Therefore you are looking in the wrong place for your workbook to open.

Ok, now i'm lost. If I ask to paste the value in a cell I do get the whole path and filename.

Please Login or Register  to view this content.

It can be you are correct. That it doesn't know where to look at. But I find it strange that I do get the correct file path.
This path is a variable that can change. So I cannot make it 'fix".

Originally Posted by bakerman2

Try this instead.

Please Login or Register  to view this content.

Weird, this now works. Thank you.
I tried it so many times didn't work. Then I must have done something wrong before.