What is the command to select a button in alert message?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to save .CSV file from hyperlink. For that when I use following command
it gives an opening alert message like "The file may contain viruses Would you
like to open the file" .For that I have to give "OK" command. How to do this
through macro programming? What is the command available to do this?

ActiveWorkbook.FollowHyperlink Address:="http://example(e.g. csv or pdf
file)", _
NewWindow:=True

(Note : I tried to avoid this alert message, but it requires windows
registry modification. I dont want to do this)
 
Thanks,

Actually my idea is to download series of .csv files through macro. I changed
the settings for .csv files through folder option menu (as given in method
-1 from website referred by you) but it is not working.
I again changed the settings for .xls files through folder option now it is
working. ( for .csv files) Thank you very much .
 
Back
Top