 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Links / October 2004clicking 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. > 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 > > 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.  SignatureHerb Martin > 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)? SignatureHerb Martin > > Or to know if there is a better way to embed local MP3 files. > > [quoted text clipped - 8 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup > 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. SignatureHerb Martin > > So in general, there is no way to turn off such messages for > > urls that resolve locally (whether MP3, html or other files)? [quoted text clipped - 9 lines] > 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. SignatureHerb Martin > > So in general, there is no way to turn off such messages for > > urls that resolve locally (whether MP3, html or other files)? [quoted text clipped - 9 lines] > 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.) SignatureHerb Martin > > So in general, there is no way to turn off such messages for > > urls that resolve locally (whether MP3, html or other files)? [quoted text clipped - 9 lines] > 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.) SignatureHerb Martin > > So in general, there is no way to turn off such messages for > > urls that resolve locally (whether MP3, html or other files)? [quoted text clipped - 9 lines] > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup A bit further research with Google and.... Windows Explorer / View / Folder Options / File Types / MP3 / Advanced / Confirm open after download = False This change will not be limited to local MP3 files but will apply to remote ones as well. Hope this solves the problem for you. Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup > A bit further research with Google and.... > Windows Explorer / View / Folder Options / File Types / MP3 / Advanced > / Confirm open after download = False That worked. Thanks. > This change will not be limited to local MP3 files but will apply to > remote ones as well. Hey, I really appreciate your help -- I was totally convinced this behavior was coming from Excel since running an MP3 file directly was NOT requiring the confirmation but apparently Excel is treating is as a "download" so that kicked in the (new?) shell protection. Has that "Advanced" button been there (on the File types) always? very long? I don't recall seeing it before. SignatureHerb Martin > Hope this solves the problem for you. > > Bill Manville > MVP - Microsoft Excel, Oxford, England > No email replies please - respond to newsgroup |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.