Trying to import filename based on cell contents

Hi,

I'm trying to import a TAB delimited text file into Excel. I've recorded a macro which has given me this (in part);

Please Login or Register  to view this content.

What I want to do is get the Macro to import a file based on the contents of cell B2 in a worksheet called 'Summary'. In my test case, I have a file called 'TEST-NAME' ready to import, and I have entered 'TEST-NAME' as text into the cell B2.

The idea eventually is to allow for us to export data from our database using our unique codes as file names (all saved in the same place), then entering those unique codes into a particular cell ('B2' for this example) for import by a good old fashioned button press. I'd obviously need to trap errors based on spelling the file name incorrectly in cell 'B2' also.

Now I'm stuck and need some help, and I have googled around all over the place to no real avail, although I do keep coming across .getOpenFileName but that doesn't look like what I'm after. I had tried something like this;

Please Login or Register  to view this content.

No joy there, but I have realised I was not referencing the correct worksheet and it wouldn't have worked anyway...I'm not sure how to reference the correct worksheet 'Summary' within the code above.

Any help much appreciated. Hopefully it's clear, I do tend to ramble...

1) Attach please a sample file with code
2) where is the text file ? in which folder ?