ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Security message when getting a .CSV file from Internet (https://www.excelbanter.com/excel-programming/338538-security-message-when-getting-csv-file-internet.html)

Timothy R. Mayes, Ph.D.

Security message when getting a .CSV file from Internet
 
I have written a add-in to get stock quotes from Yahoo! Finance. What I'm
doing is building the URL for multiple tickers and then using the
FollowHyperlink function. This pulls down a .CSV file into an Excel
workbook. Works great, except that I get a message box saying that it is
opening a file with the URL as a name and that "some files may contain
viruses....Would you like to open this file?"

I would like to stop that message box from appearing. Since it is a plain
text .csv file, it is perfectly safe. Also, the message box has no effect
at all. If I click the OK button, the file loads and everything works fine.
Strangely, if I click the Cancel button the exact same thing happens.
Anyway, I've tried every trick I can think of to get rid of it.
Application.DisplayAlerts = False doesn't work, nor do the several other
things that I tried (basically some things I found in the help file and I
now can't remember).

I'm not even sure what application is launching this message box. The title
of the message box is "Microsoft Office". When using the FollowHyperlink
function to download a file does Excel invisibly launch the default browser?
I have set screenupdating to false while downloading and processing the .csv
file, but even with it set to true I've never seen a browser window open.

Any ideas?

Thanks,

Tim




All times are GMT +1. The time now is 05:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com