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. So after further research I have learned it is looking for the current date of when I set up the data connection not the current date. So if I put my file in the correct folder with YESTERDAYS date it will work... How do I get the Data Connections to update so it looks for the file with the current date and NOT the date I set up the connection?? Any thoughts or advice?
Bookmarks