View Single Post
 
Old 02-17-2014, 11:25 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

AFAIK you can't do that via a formula. Although you could insert a hyperlink to any file within the zip archive, it's Excel that will try to open it, not the application with which the extension is associated.

It might be possible to do what you want via a macro, but that depends on whether:
• your player accepts command line inputs; and
• those inputs can be to a file within a zip archive.

A trivial demonstration of what can be done with a macro (aka vba) is:
Code:
Sub Demo()
Shell "C:\Windows\Notepad.exe", vbNormalFocus
End Sub
That little sub will open the Windows Notepad.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote