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)