Hi All,

I searched the forums for this but couldn't find anything appropriate.

I have a project where the final Excel spreadsheet will be stored online for users to download. Occasionally the file will be updated with a new version but I want to make sure that users who have downloaded an older version are alerted if there is a more up-to-date file available.

I want to write a piece of VBA that will check the name of the current file and compare it to the name of the file available for download. Ultimately I want to be prompt the user to download the newer version if/when appropriate.

Does anyone know of an elegant way of achieving this? Essentially, I just need the VBA to read the filename in the specified online directory. If that's not possible, I thought I might have to upload a hidden 'version control' txt file to the directory with a standard name, which VBA can download and open and read the most up-to-date filename from.

Any thoughts?

Cheers,
Ad