ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2007 Shell Command Runtime Error HELP (https://www.excelbanter.com/excel-programming/417390-excel-2007-shell-command-runtime-error-help.html)

KJ MAN[_2_]

Excel 2007 Shell Command Runtime Error HELP
 
In Excel 2003, this code worked fine

Private Sub CommandButton1_Click()
Worksheets("Player").Activate
Range("B4").Select
PlayFile = Shell( _
"C:\Program Files\Windows Media Player\wmplayer.exe ""E:\" &
ActiveCell.Value & """", 1)

Worksheets("Player").Range("A4:C4").Delete Shift:=xlShiftUp

End Sub

In Excel 2007, Windows Media Player opens, but I get a
Microsoft Visual C++ Runtime Library error.
Runtime Error!

Program: C:\Program Files\Windows Media Player\wmplayer.exe

This application has requested the Runtime to terminate it in an unusual way.
Please contact the application's support team for more information.


Can anyone explain to me why?

Thanks in advance



All times are GMT +1. The time now is 06:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com