ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   What is the command to select a button in alert message? (https://www.excelbanter.com/excel-programming/391030-what-command-select-button-alert-message.html)

ezil

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)

Gary''s Student

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)


ezil

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