Re: for/each followhyperlink address

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: David McRitchie (dmcritchie_at_msn.com)
Date: 03/13/04 

Date: Fri, 12 Mar 2004 21:49:06 -0500

Hi Don,
I have an example to play all the .WAV files on my system
from a worksheet. It uses a column for selection/rejection/terminate
   Fun Stuff
   http://www.mvps.org/dmcritchie/excel/funstuff.htm 

---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm
"Don Guillett" <donaldb@281.com> wrote in message news:enll$LGCEHA.3848@TK2MSFTNGP11.phx.gbl...
> Posted yesterday on the L list with no response so trying here.
>
> Not much to do today so listening to some music. xl2002.
> I use something similar to this to play .mp3's from a double click event
> using the typed name of the file. Now, I want to be lazy and have it play
> more than one selection in a for/each loop. As usual it will play the
> selection but when the song is finished I am still at wmp.
>
> The question is how do I play the next song in the selection?  TIA
>
>       C:\GordonLightfoot2\Gordon Lightfoot - Seven Island Suite.mp3
>       C:\GordonLightfoot3\Gordon Lightfoot - Shadows.mp3
>       C:\GordonLightfoot2\Gordon Lightfoot - She's Not The Same.mp3
>
> Sub playselections()
> For Each c In Selection
> mc = Cells(c.Row, "e")
> x = Right(Application.OperatingSystem, 4)
> If x < 5 Then
>   cmd = "Start " & Chr(34) & mc & Chr(34)
>   Shell cmd 'works with xl97
> Else
>   Dim FullFileName As String
>   FullFileName = mc
>   ActiveWorkbook.FollowHyperlink Address:=FullFileName
> End If
> Next c 'song
> End Sub
>
>
> -- 
> Don Guillett
> SalesAid Software
> donaldb@281.com
>
>
>

Relevant Pages

  • for/each followhyperlink address
    ... I use something similar to this to play .mp3's from a double click event ... selection but when the song is finished I am still at wmp. ... The question is how do I play the next song in the selection? ... Dim FullFileName As String ...
    (microsoft.public.excel.programming)
  • Re: Madden NFL 96
    ... Use the control pad to move the cursor to highlight CHOOSE SEASON MODE, CHOOSE PLAYER, CHOOSE HOME TEAM, CHOOSE HOME PLAYER, or CHOOSE QUARTER LENGTH. ... If your selection is REGULAR SEASON or SUDDEN DEATH press the START BUTTON to raise the SCOUTING REPORT SCREEN then press the A BUTTON to begin gameplay. ... A BUTTON- Call audible play option, Call audible trick play, Runner dives, Pass to receiver A, Diving catch, Call time out ... Once you have selected your players press the corresponding A, B, or C BUTTON to raise CHOOSE FORMATION,. ...
    (rec.games.video.sega)
  • Re: Kaifs recent FC Record
    ... > Kaif's selection is not based on FC stats - as someone said the other ... His footwork is good; can play ... > down by good quality bowling. ... > But I see reasonable argument on the other side and would not dismiss ...
    (rec.sport.cricket)
  • Re: Brussow Hollywood
    ... the discussion for an All Black touring party. ... selection by smacking his main rival, an All Black incumbent, in the ... He used to play wing for the Navy and Combined Services. ...
    (rec.sport.rugby.union)
  • Re: 2011 Whiterose Gameroom Show (the York Show)
    ... my sincere appreciation to all the hard work ... Great selection of flea market finds, ... always a great play, the BBB was amazing, the prices were somewhat ... games to play, great selection of games as well. ...
    (rec.games.pinball)