Hi All,
Hope you can help with some Excel VBA
I'm trying to build a Macro to retrieve the File Path of a file that is within a specified Folder Path that is currently in Cell A1 ( Full Folder path is in Cell A1) and place the retrieved file path within B1 ( There will only ever be 1no. file with the folder at any one time).
then do the same for A2 with the File path in B2 etc. ( note : The folder path in A2 will be different to A1 and then hence will be a different File path in B2)
I have approximately 500 Rows within excel to do this with.
I have tried some coding myself and happy to share but i do feel I'm already heading down the wrong road.
Hope i have managed to explain this correctly and many thanks in advance for any help.
Thanks
Juicy2052
Bookmarks