Article View: comp.lang.basic.visual.database
Article #63Re: Help with Shell command from VBA in Excel
From: Steve Silberberg
Date: Tue, 11 Nov 1997 00:00
Date: Tue, 11 Nov 1997 00:00
29 lines
2011 bytes
2011 bytes
In article <eMSu6op78GA.266@uppssnewspub04.moswest.msn.net>, "Jim Rech" <jarech@kpmg.com> wrote:
>We're not communicating. I'm asking what happens when you supply the window
>style parameter like this:
>
>Shell "c:\winnt\system32\mplay32.exe /Play /Close c:\warning.wav", 1
>
>No Sendkeys at all.
Jim,
THANK YOU THANK YOU THANK YOU!!!!!!
That worked great! The philosophical bit of information I was missing was the
command line parameters to mplay32.exe. I didn't realize that Excel was
working fine, but the player needed command line switches. I pored over
mplay32's on-line documentation and found no mention of it. Furthermore,
mplay32 /?
returns nothing in Dos. So THANK YOU again.
One more question if I may. How do I get this warning to play as an
auto execution macro at start up?
Steve
----------------
Steve Silberberg
mailto:stevebo@onramp.net
Visit the Air Sickness Bag Museum at:
http://rampages.onramp.net/~stevebo/airsick.html
FACT: Buff Babes Dig Cut Dudes!
Technical Details
Message-ID:
<64aaei$hdt@news.onramp.net>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<646ctu$l5j@news.onramp.net> <eEQUdEg78GA.99@uppssnewspub04.moswest.msn.net> <6494av$a7i@news.onramp.net> <eMSu6op78GA.266@uppssnewspub04.moswest.msn.net>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 1112c7,32ea6480e39b375 X-Google-Attributes: gid1112c7,public X-Google-Thread: 10b213,32ea6480e39b375 X-Google-Attributes: gid10b213,public X-Google-Thread: fd1b2,32ea6480e39b375 X-Google-Attributes: gidfd1b2,public X-Google-Thread: fad30,32ea6480e39b375 X-Google-Attributes: gidfad30,public X-Google-Thread: 1143a7,32ea6480e39b375 X-Google-Attributes: gid1143a7,public From: stevebo@onramp.net (Steve Silberberg) Subject: Re: Help with Shell command from VBA in Excel Date: 1997/11/11 Message-ID: <64aaei$hdt@news.onramp.net> X-Deja-AN: 288678736 References: <646ctu$l5j@news.onramp.net> <eEQUdEg78GA.99@uppssnewspub04.moswest.msn.net> <6494av$a7i@news.onramp.net> <eMSu6op78GA.266@uppssnewspub04.moswest.msn.net> Organization: Callipygian Productions Newsgroups: comp.lang.basic.visual.database,dfw.test,microsoft.public.excel.misc,microsoft.public.vb.controls,microsoft.public.word.vba