Hello friends,

I used hyperlink connection to open few link to pull the data.
Warning message appears like: some files can contain viruses or otherwise be harmful to your computer.... with OK & Cancel button.
Please anyone can help how to disable this message.

Run the hyperlink in loop, warning message shown for continue to loop end. Manual click OK there after go to the next.

if possible macro code to click OK button or some other method.