Tweak my code please to import excel sheets.

I'm running into a little trouble with this code. I have commented the trouble spot.
Cell "B4" would be populated from an input box.
The variations in "B4" could be up to 8, but may be as few as 1.

Please Login or Register  to view this content.

Thanks

I have to have the "40X" portion of the entry. I have played with wildcard such as " *40X* " and seem to run into problems. I'm sure it's just a syntax mistake, but can't seem to find it.

Keep in mind that there may only be one file to import "W40X".

Maybe I need some error checking...???



'do you think this would work???
'************************************************************************

Please Login or Register  to view this content.

'************************************************************************
Adding wildcards around the filename selected ???

Please Login or Register  to view this content.

creates a problem because the filenames would be a list of different names like this...

W40X120.xls
W40X90.xls
WB40X120.xls
WS40X90.xls

etc.