Macro to open file from partial name ?

[Rich]

Hi,

I have an external application which dumps data to text files which I then
work on using excel. I'm trying to write a macro to automate the batch
conversion process, but I have a problem because the external application
names the files with a date appendage (see example below) :-

B_Report_011103.txt

I do need to keep the date in the excel file name if possible.

How can I get excel to open any filename begining with the string "B_Report"
? Is there any way of adding a wildcard to the file name string ?

Rich

 

[Bob Phillips]

Rich,

See responses in .misc. If you want to hit many groups, do it in a single
post, not multiple posts, it makes life easier for all concerned.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)