I have always done this with an activeX control, I'm not sure if there is another way (there must be, but this control allows me to set it to start in a specific folder). How does the file name change every day? I ask because If it is just a date it's easy enough to set your file name dynamically.
Hope this helps,
Alex
A wise man once said
"The only thing normal about database guys is their tables".