This will pull out the address, and show you how to use instr()
I replaced the " with "" to get it into a string.

VB Code:
  1. Option Explicit
  2.  
  3. Private Sub Form_Load()
  4.   Dim t$
  5.   Dim sstart As Integer, sstop As Integer
  6.   t = "<embed width=""550"" height=""400"" src=""http://agflashfarm.com/D78AQSAKQLQWI9/2019.swf quality"
  7.   sstart = InStr(t, "src=") + 5
  8.   sstop = InStr(t, " qual")
  9.   MsgBox Mid$(t, sstart, sstop - sstart)
  10. End Sub