Execute Macro for multiple text files

Hi,

I have multiple text files and i have a .xlt macro file. when i run this .xlt file using execute macros. It opens a dialogbox and asks me to select the text file. so how could i automate this macro for multiple text files?

Thanks,
Soorya