![]() |
What is the command to select a button in alert message?
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) |
What is the command to select a button in alert message?
See:
http://support.microsoft.com/Default.aspx?kbid=829072 -- Gary''s Student - gsnu200728 "ezil" wrote: 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) |
What is the command to select a button in alert message?
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 . "Gary''s Student" wrote: See: http://support.microsoft.com/Default.aspx?kbid=829072 -- Gary''s Student - gsnu200728 "ezil" wrote: 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) |
All times are GMT +1. The time now is 11:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com