Drive letter from cell reference

[Will31]

Hi All,

I need to use something similar to the below code to take the contents of cell D7 on sheet T Dash (In workbook Overview which is where the macro is running) to afford the drive letter:

Please Login or Register  to view this content.

I tried to use;

Please Login or Register  to view this content.

but it didn't work.

Any ideas

[JBeaucaire]

This works for me, I would expect your string results in a bad path/filename.

Please Login or Register  to view this content.