View Single Post
 
Old 02-18-2014, 02:17 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

Quote:
Originally Posted by pemartins View Post
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.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote