Hi Guys,
The following code is creating multiple instances of Excel in my Access app and I can't get rid of them. The QUIT method does not work. What am I doing wrong?
Private Sub List5_DblClick(Cancel As Integer)
On Error Resume Next
Dim objSpread As WebBrowser
Dim SAddress As String
Set objSpread = Me.ActiveXCtl16.Object 'WebBrowser control
SAddress = List5.Column(2) 'List box Excel file selector
Me!LinkSpreadFileBar = SAddress 'Info file text box
objSpread.Navigate SAddress 'Get & display Excel file
Set objSpread = Nothing
End Sub