davidbenson3
03-03-2008, 11:02 AM
:dunno
I currently have a VBA macro in Excel that uses Now() to populate a date variable. The variable is used internally to prompt a user to renew if the license has expired. Since a user can easily bypass this by changing the computer system date, I would like to find some VBA code that will first attempt to retrieve a current date from a source on the internet and populate the variable with that value instead. If any errors occur, or the person doesn't have an active internet connection, it could still use Now() as a fallback option. Is this possible? Thanks in advance for any assistance! :thumb
David
I currently have a VBA macro in Excel that uses Now() to populate a date variable. The variable is used internally to prompt a user to renew if the license has expired. Since a user can easily bypass this by changing the computer system date, I would like to find some VBA code that will first attempt to retrieve a current date from a source on the internet and populate the variable with that value instead. If any errors occur, or the person doesn't have an active internet connection, it could still use Now() as a fallback option. Is this possible? Thanks in advance for any assistance! :thumb
David