Formula to open external file with specific program (like open with)

macropod · #4 02-18-2014, 02:17 PM

Quote:

Originally Posted by pemartins

By the way, is it possible to do something like this (can't test it at the moment):

Code:

Sub Demo()
Shell "C:\Program Files (x86)\KaraFun Player\KaraFunPlayer.exe" "<my sheet's E column here acording to the song, like E5 for Another Day In Paradise>"
End Sub

And if so, how could I make the column change according to request song?

For that, you'd need to use something along the lines of:

Code:

Sub Demo()
Shell "C:\Program Files (x86)\KaraFun Player\KaraFunPlayer.exe \o " & .Range("A5").Text
End Sub

where \o is the (assumed) command-line switch to open a file and '.Range("A5").Text' is the contents of a cell holding the full file path & name.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can I run a macro when I open a specific doc ??	ximpostor	Word VBA	10	10-12-2012 12:35 PM
Preventing word/excel from trying to open external template locations	Perhill	Office	0	03-02-2011 04:44 AM
changing default program from works to word to open attachments	catskier	Outlook	0	03-10-2009 01:35 PM
Can't open the program/Was trying to setup email	lbauge	Outlook	1	04-18-2006 03:40 AM
I cannot open a hyperlink in an office 2003 program	ArmandoS	Office	3	11-26-2005 12:11 PM