Now write in vba program in execl, read the data within a specified file on the site, need to determine if the file exists, or directly open will error and is unable to continue,
Can't I tried dir and FileSystemObject fileexists
The website file address at https://www.ark-funds.com/auto/trades/ARK_ARKF_Trades.xls
Trouble ace to give directions how to determine if the file exists
Thank you
CodePudding user response:
Can only download files directly with XMLHTTP, to 404 there is no wrong,CodePudding user response:
If just judge file is here or not, is not necessarily all download, as long as sending HTTP download requests, opposite the server did not return an error description file exists, of course, can also be to return a custom 404 interface, want oneself to judge,