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)

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)

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)