Hello
I need an if then or else statement that will check an https:// SharePoint url to see if a file exists. If it does, then a msgbox that will ask if you would like to overwrite. If not then exit Sub.
The problem I'm experiencing here is:
Url access to SharePoint does not require a password because it's already part of the proxy settings.
If I backdoor into the SharePoint site via the network path it tends to break VBA and rarely works because a password is required.
As this Excel file will be used by multiple users I don't want to use that method.
The DIR function doesn't work with URLs... So.. any ideas?
Thanks in advance
I need an if then or else statement that will check an https:// SharePoint url to see if a file exists. If it does, then a msgbox that will ask if you would like to overwrite. If not then exit Sub.
The problem I'm experiencing here is:
Url access to SharePoint does not require a password because it's already part of the proxy settings.
If I backdoor into the SharePoint site via the network path it tends to break VBA and rarely works because a password is required.
As this Excel file will be used by multiple users I don't want to use that method.
The DIR function doesn't work with URLs... So.. any ideas?
Thanks in advance
