Opening A File That Names Changes Daily

I am attempting to place a link in an Operations News Letter to an Excel file that's name changes daily. Rather than having to change the link every day, is there a "wild" character that can be used to open this Excel file no matter the name? It's the only Excel file in this directory.
Robert PollickConfiguration ManagerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RustyZ32Commented:
not sure how to link with a wildcard but you can rename hte file using a wildcard.

for example, whenever the file is changed create a .bat file and schedule it to run shortly thereafter.

.bat file would look something like:

rename c:\docs\*.xls link.xls

this will rename the file to "link"

if you cannot rename it for other reasons then first do a copy to anotrher directory, then the rename and set your link to the new directory.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Robert PollickConfiguration ManagerAuthor Commented:
Okay. The file name is "filename_mmddyyyy.xls". In the script rather than rename it what would be the Office scripting to save another copy, say as "filename.xls", that would overwrite itself each day? We need to keep the dates on these files for archiving purposes.
0
Robert PollickConfiguration ManagerAuthor Commented:
I didn't read the message carefully enough. That would be a good solution. Thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Legacy OS

From novice to tech pro — start learning today.