View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
teepee[_4_] teepee[_4_] is offline
external usenet poster
 
Posts: 27
Default Need help referencing an embedded file in Excel


"Vasant Nanavati" wrote...
Dim Mfile As Object
Set Mfile = Sheet1.OLEObjects("Object 6928")


Hmm no luck

The whole subcommand for this button now reads

Private Sub CommandButton1_Click()
Dim Mfile As Object
Set Mfile = Results.OLEObjects("Object 6928")
MP.Open (Mfile)
End Sub

(results being the name of the sheet and media player being what opens it)
It says runtime error 424 object required