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

pemartins · #1 02-18-2014, 11:57 AM

Thank you very much for your answer. I'll test it as soon as possible and I'll get back to you.

There's no need to link inside the zip file (I think) because the player (KaraFun Player) opens zip files. In cdg+mp3 files format there is a cgd file and a mp3 file, both with the same name, so it's normal and convenient that they are both zipped into one single file. And the player is prepared for this.

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?

These are probably very dumb questions since I never tried any macros or vba... I'll try it as soon as possible.

Thank you very much once again!

macropod · #2 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