Hi all, first post.

I am working with excel files which get their data from htm files on the same folder location. Every time I open the xls file I get a prompt "Some of the files in this web page arent in the expected location. Do you want to download them anyway? If you're sure the web page is from a trusted source, click yes" and there are buttons for yes, no and cancel.

Is there some vba code (I am using v6) I can write which will select "Yes" when the file is being opened so I dont have to click every time?

Thanks for your help.