VBA - User Prompted to choose source file for Vlookup, Error after file is opened

This macro is just a vlookup. It is supposed to run column A in SITELIST_MACRO against column A in the file the user is prompted to open. Running into an error at the vLookup line. "application-defined or object-defined error"
I am currently at the following code:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

You need to incorporate myFileNamein the formula.

Please Login or Register  to view this content.

By the way, what is the code actually meant to do?

I'm asking because you open a file, add a load of formulas to a sheet on the file and then close the file without saving.

Also, there's only one column in the lookup range so the vlookup isn't really going to do much.

If the lookup range is only one column then the VLOOKUP will just return the value you are looking up.

If you want to just find if a match is found use MATCH.