|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
|
|||
|
|||
|
Successive WebBrowser calls taking up memory
Running the following code is giving me Virtual Memory warnings when I get to about the 5,000th call(keyword).
' User calls this to start running the AutoBrowse program Public Sub StartItAllUp() Dim rngCategory As Range, rngKeyword As Range Set rngKeyword = Application.Selection frmWebWindow.axcBrowser.Navigate GetAddress(rngKeyword.Text) End Sub ' When navigation to my keyword is done this events get fired by the WebBrowser control Private Sub axcBrowser_DocumentComplete(ByVal pDisp As Object, URL As Variant) AutoBrowseKWApproval End Sub Public Sub AutoBrowseKWApproval() dim strBrowseResults as String strBrowseResults = frmWebWindow.axcBrowser.Document.body.innertext ' [code here that uses the strBrowseResults to in/validate the Keyword in question] Application.Selection.Offset(1, 0).Select Set rngKeyword = Application.Selection If rngKeyword.Text <> "" Then frmWebWindow.axcBrowser.Navigate GetAddress(rngKeyword.Text) End If End Sub |
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Successive WebBrowser calls taking up memory |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|