Opening workbooks in code with partial name... (2000 SP-3)

Here's what I have... Column A contains 6 character strings... These strings represent the first 6 characters of .xls file names (all unique to one particular file) in a certain directory... I need to loop through the list... opening the file, doing some other stuff and then closing the file...

I can't get the file to open... I've done this code many times with the FULL file names... I thought that I could use a wildcard character when specifying which file to open, but it's not working... Is this possible??

Re: Opening workbooks in code with partial name... (2000 SP-3)

Works perfectly Hans... <img src=/S/doh.gif border=0 alt=doh width=15 height=15> My code was almost identical...
I won't tell you what I was missing or you'll lose all respect for me (If you ever had any!)... <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>