insert a text file with a changing name

hi all,

i have a text file that i want to insert into excel daily. the issue is the name will change each day.

data_20121212.txt tomorrow it will be data_20121213.txt

I have a cell on my sheet with the date part, but i can not get excel to insert the cell data into the path name.

this is the start of the code i have now

Please Login or Register  to view this content.

Any help would be great

Moderator's Note: You have to put code tags around codes. Select the code then hit the "#" sign. I'll do it for now. Thank you.