MACRO help- opening hyperlink through Command Prompt

[kvizzle321]

Here is my issue.

I have an excel file with about 5000 filepaths listed in it along with project #, Revision #, extension type, notes etc. All of these files are hyperlinked so you can open them just by clicking.

However, every time I open these files (most of them are AutoCAD .dwg files), I get the prompt "Opening [filename.dwg] Some files can contain viruses or otherwise be harmful to your computer. It is important to be certain that this file is from a trustworthy source. Would you like to open this file?"


Of course I press OK each time, however this gets very very tedious, and I have to open many files so I would like for it to stop.

I tried all Windows7/Excel/Microsoft Office options to trust the location I'm using and the file type, but the prompt still comes up every time.

If I open these files through command prompt, I wont get the annoying prompt warning me.....does anyone know a macro that could let me click on the file hyperlink and either suppress this prompt, open the file through command prompt, or both?

Thanks in advance


-kevin

 

[kvizzle321]

bump --any help would be greatly appreciated!

 

[kpark91]

Run this code to disable displaying alerts

Application.DisplayAlerts = False

use this to enable them back on.

Application.DisplayAlerts = True

 

[kvizzle321]

i think i did it correctly (put in VBA and run code?)

but to no avail. i still get the alert (which is coming from Microsoft Office, not windows or Excel)

 

[kvizzle321]

bump-- any other advice?

 

[kpark91]

Looks like the HLINK.DLL may be the problem.
It is your windows registry that keeps popping up your warning messages.

Try visiting this website:
http://support.microsoft.com/kb/925757

 

[kvizzle321]

thanks for the link, I think i had seen that before, but i tried every single solution they had multiple times, to no avail

is this problem really impossible to solve!??!

 

[kvizzle321]

bump---any enlightened individuals that know how to solve this?

 

[kvizzle321]

bump....i know someone out there has the answer

 

[kvizzle321]

**bump***

last try....please help :'(