Once a month, research releases a new downloadable excel file with stock ratings. I would like to have a macro in my stock analysis worksheet that will prompt me to download the new data when I open the workbook if a new file is available. The catch is that it is a large file, and I don't want it to download until the user asks it to update. I already have the macro written to download and process the file, but it doesn't check for a newer version.

Part of the url for the file is: EC%5FUniverse%5F2010%5FSeptember%2Exls.
I would like an alert to pop up when the file called EC%5FUniverse%5F2010%5FOctober%2Exls is available. Any advice?

pthom14, welcome to the Forum.
You should not need to try and find a Month Name embedded in the File's name. You should be able to use the File System Object to return the date the File was last Accessed or maybe the date created.
You use it like this
variable = FileDateTime(File location)
Where File location is the Folder path to where the document file is located.

Thanks OBP. I'm not sure this applies to what I'm trying to do. I'm trying to test if the current month's file is available for download from the Internet yet or not. I would like the macro to return true if the file is available, false otherwise. Do you know of something similar for a website?

Will the older file still be there or does this one replace it?
Is the rest of the URL the same in each case?
If so you could store the URL for the current file and compare it to the one on the website.

I also found this which opens a web page, I would assume that if the web page does not exist you will get an error message, you could then use erro trapping to stop any attempted download.
Application.Workbooks.Open ("http://www.geocities.com/johnske100/TheFINDfunction.html")
This extrac is from this linkhttp://www.vbaexpress.com/kb/getarticle.php?kb_id=295

THIS THREAD HAS EXPIRED.
Are you having the same problem?
We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.