The VBA Shell command won’t take a document file as its parameter…it must be of the form “program.exe parameters”.  However, Boston WorkStation’s Shell_  does, so I’d suggest adding an underscore to the end of the Shell command.

 

Rich McNeil

Boston Software Systems

866 653 5105

www.bostonworkstation.com


From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of White, Scott A
Sent: Friday, January 21, 2005 9:54 AM
To: [email protected]
Subject: [Talk] Launching sound file

 

Hello everyone,

 

I have a procedure that I want to call if a certain condition exists.

Basically, I want an audible sound to draw my attention to my p.c..


 Sub SoundAlert()
    Shell "C:\WINNT\Media\Microsoft Office 2000\CHIMES.WAV"
 End Sub

 

I get - "Invalid procedure call or argument".

 

Can anyone tell me why it doesn't work?

 

Thank you,

Scott

 


CONFIDENTIALITY NOTICE: This e-mail communication and any attachments
may contain confidential and privileged information for the use of the
designated recipients named above.  If you are not the intended
recipient, you are hereby notified that you have received this communication in
error and that any review, disclosure, dissemination, distribution or copying
of it or its contents is prohibited. If you have received this
communication in error, please notify Saratoga Hospital immediately by e-mail at
[EMAIL PROTECTED] and destroy all copies of this communication
and any attachments.

Reply via email to