JonathanDK
New Member
- Joined
- Jan 31, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
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
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