Hello Everybody,

So I have encoutered a problem with the Data Connections in excel.... Let me give you a little background to better understand the problem. Everyday I run a process that creates a file with the current date for example karagill120512.txt. I have to import this file everyday into an excel template. I am trying to automate this process.. So what I wanted is when I opened up my spreadsheet it would automatically import the file without having to pick the file. The way I did this way when I was setting up the data connections I used an excel formula karagill=TODAY(). It worked beautifully but the next day when I opened the spreadsheet is says it cannot locate the file..... How do I get this to work everyday without having to edit the query? Any ideas or help on this would be GREATLY appreciated!!