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

  • [xpost][/xpost]

    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.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!