File equals cell value problem

Hello All,

I am trying to use a macro to import all file names in a folder. I found the following which works perfectly:

Please Login or Register  to view this content.

The problem is I want the file path to be what is in cell V1, I tried

Please Login or Register  to view this content.

But this didn't work, I thought I was in the right area with that one but, after trying various versions of it I have gotten nowhere!

Any advice would be most greatfully received!

Thanks,

Dean

You could check out over here.