Code to read text filename in a cell, to then put into the pathway for that file.

[JonathanDK]

Hi. I'm very new to VBA.

I've been trying to make a code to work that looks at the value of a cell in one worksheet in a folder. This is a filename. Then include this in the pathway in the code (the pathway the folder is always the same - it's only the filename that changes by date).

I can make it work if I put the filename manually into the code...but the whole point is the code reading the filename from the cell and this then opening the other workbook that is in a different folder. I hope that makes sense

Yours

Jonathan

 

[johnnyL]

Post the code you have now.