clicking on an MP3 file requires confirmation (how to disable?)

Excel (2003) is offering a confirmation dialog whenever an
url pointing to an MP3 file is clicked?

Can this be (easily) disabled?

....or what is an approach to it for files on one's own hard drive.

I am linking a list of vocabulary words in one field/column with an
MP3 file name in another field/column with a formula using:

=HYPERLINK(F1,E1)

All MP3 files are local.

Herb Martin wrote:
Excel (2003) is offering a confirmation dialog whenever an
url pointing to an MP3 file is clicked?


What does the dialog say?


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

"Bill Manville" wrote in message
...
Herb Martin wrote:
Excel (2003) is offering a confirmation dialog whenever an
url pointing to an MP3 file is clicked?


What does the dialog say?



"Opening [filename]"

"Some files can 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?"

These are trusted files from my own drives and I would prefer not having
the message displayed (without disabling ALL Office security.)

Or to know if there is a better way to embed local MP3 files.

FYI: I have vocabulary files for language learning and these
are the MP3 files that pronounce each word or phrase.


--
Herb Martin

Herb Martin wrote:
Or to know if there is a better way to embed local MP3 files.

I'm not an expert on this and I have no MP3 files, but could you insert
the file in the workbook?

Insert / Object / Create from file / Link to file
Then double-clicking on the icon should play the file without a
warning.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

I'm not an expert on this and I have no MP3 files, but could you insert
the file in the workbook?

I need to automate it to arrange that -- I have ~1800 of these
in multiple files, and over 1000 in some other files. grin

I suppose I can test it with one file and if it works record the
action a macro which can then be fed by the list of file names
(with a bit of modification.)

I am not a superb macro programmer but usually I can work
out how to modify a recorded macro to cause it to repeat for
similar data lists.

So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?

--
Herb Martin


"Bill Manville" wrote in message
...
Herb Martin wrote:
Or to know if there is a better way to embed local MP3 files.

I'm not an expert on this and I have no MP3 files, but could you insert
the file in the workbook?

Insert / Object / Create from file / Link to file
Then double-clicking on the icon should play the file without a
warning.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Herb Martin wrote:
So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?


2 minutes research with Google looking for "Some files can contain
viruses" led me to:

http://support.microsoft.com/?kbid=829072

which provides the solution.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thanks.

Usually I search Google first but for Office made the mistake
of relying solely on the Help. Silly me.

Unfortunately, this setting (it mentions) turns off the warnings
equally for MP3 and even for executable files whether local
or remote.

I do appreciate the help. Thanks.


--
Herb Martin


"Bill Manville" wrote in message
...
Herb Martin wrote:
So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?


2 minutes research with Google looking for "Some files can contain
viruses" led me to:

http://support.microsoft.com/?kbid=829072

which provides the solution.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Odd situations:

Even before adding the registry key all HTML links worked
without the message.

Even after adding the key (and re-starting everything Office
related) the MP3 files get the warning.

Odd.

I would much rather it worked the other way around.

--
Herb Martin


"Bill Manville" wrote in message
...
Herb Martin wrote:
So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?


2 minutes research with Google looking for "Some files can contain
viruses" led me to:

http://support.microsoft.com/?kbid=829072

which provides the solution.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Another update (FWI):

Using Insert OBJECT (from File) created a item not located
in a specific sell and did not operate when clicked even though
it also offered a (similar but different) warning/confirmation
dialog box.

Even after accepting, it did not play although it showed up
over in WinAmp (as did the straight MP3 files.) This could
be a WinAmp problem however.

But despite the registry change these files are still requiring
confirmation.

Adding it as a Windows Media Player object just made a
mess (it added a Media Player window rather than a simple
link to it -- this isn't suitable for 1000+ media files.)

--
Herb Martin


"Bill Manville" wrote in message
...
Herb Martin wrote:
So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?


2 minutes research with Google looking for "Some files can contain
viruses" led me to:

http://support.microsoft.com/?kbid=829072

which provides the solution.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Another update (FWI):

Using Insert OBJECT (from File) created a item not located
in a specific sell and did not operate when clicked even though
it also offered a (similar but different) warning/confirmation
dialog box.

Even after accepting, it did not play although it showed up
over in WinAmp (as did the straight MP3 files.) This could
be a WinAmp problem however.

But despite the registry change these files are still requiring
confirmation.

Adding it as a Windows Media Player object just made a
mess (it added a Media Player window rather than a simple
link to it -- this isn't suitable for 1000+ media files.)

I am pursuing the failure of the Registry key and such still
(perhaps I made a spelling mistake or something that I
haven't located yet.)

--
Herb Martin


"Bill Manville" wrote in message
...
Herb Martin wrote:
So in general, there is no way to turn off such messages for
urls that resolve locally (whether MP3, html or other files)?


2 minutes research with Google looking for "Some files can contain
viruses" led me to:

http://support.microsoft.com/?kbid=829072

which provides the solution.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup