How to auto open file from hyperlinks?

[David1874]

Hello,

I am working on a marco in excel that can automatically open a file with link stored in cell B4. Here is the part of code for opening the file:

Range("B4&quot.Select
Selection.Hyperlinks(1).Follow NewWindow:=False,
AddHistory:=True

If the file is .txt, then it works fine. But since the file is of a different type (.dxw), a popup window with title "microsoft office" saying that the file can contain virus, and ask user to click "ok" to continue open the file. I would lke to know how to automatically click "ok" button without notifying the user? I'm using office 2000.

Thanks a lot!!!

 

[TopJack]

You could use this :-

Sendkeys "{ENTER}", True

but its not good, other events can complicate this, there must be a better way.

 

[David1874]

Thanks you....I now know the answer,

just uncheck the "confirm open after download" option of the file extension under folder option, then no popup will appear again.