I run this macro successfully in a previous computer but the download does not happen in the new computer. I have tried to see if it is being blocked by the firewall but this did not help. The macro does not stop at the failed download. Every other line executes. I am at a loss
Hi
Is the url still valid? It is always advisable to check such as:
sUrl = "http://....."
if fileExists(sUrl) then
print "ok => loadcomponentFromUrl"
else
print "ko"
end if
Regards
Yes! I did a direct entry of the url into Chrome and the csv downloaded and I opened in a libre spreadsheet. The error must be in the next part of the macro where it is copied and pasted into the correct sheet. I tried to show this part of the macro but it exceeded the length allowed.
Thanks
What puzzles me is that the macro still works perfectly in the previous computer but fails in the new one. It suggests that something outside the macro is preventing execution without any notification.