Get filepath that is written in a cell, to be used with the File.Contents function

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question

    Hi Need help with this code. It is very messy, because I recorded the macro, but I need help to get the filepath, that i have in a cell called "filePath", in the File.Contents function. Thanks for your help.




  • Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post


    All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.


    How to use code tags


    Just highlight all of the code and press the <> in the post menu above button to add the code tags.




    Thanks.