Macro with Vlookup

[Guest]

I am trying to write a simple macro with a vlookup contained in it. The
trick is that the vlookup in the macro must be flexible to look in another
excel file for data. The user will decide the name of the file to go into
the macro. My problem is that when I recored the marco the name of the file
I use as an example gets hard coded in, and this defeats the purpose.
Suggestions?

 

[Don Guillett]

Always copy/paste your code here for comments.