I built a VBA app in Excel and I am trying to set the application up to check for the existance of a webpage when it is opened. If the webpage no longer exists then the application quits before loading any code and is useless.
This way I can disable the use of the application if I remove the file from my webserver.
The problem I am running into is the file keeps being saved into the temporary internet files so even if I delete the file from the internet, its reads it from the cache and proceeds with the program.
Here is what I am using:
Private Sub Workbook_Open()
On Error GoTo UnAuth_Shutdown
MsgBox "Access Granted"
If the internet file does not exist it throws off an error and it sends it to a shutdown sequence. If the file is present it closes it with no error and continues to execute my code.
After it loads the file once though, the 65483.html file is saved in the cache so even when I remove it from the web it still finds it in the cache - doesn't throw the error and continues to execute the code.
Any advice on how to fix this or a better way to go about this all together.