If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
"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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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 |
#10
|
|||
|
|||
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 |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
URGENT: Mailing rule problems of filing in outlook express and hard copy file systems in real case | Teres | Outlook Express | 7 | August 14th, 2004 01:55 AM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
Unsafe Attachments | Ron | Installation & Setup | 2 | June 9th, 2004 01:55 AM |
GPO Office 2003 | Tony | Setup, Installing & Configuration | 1 | May 12th, 2004 10:42 AM |
Default File Location | Derek Ruesch | Setting up and Configuration | 6 | January 30th, 2004 03:03 AM |