Code:
Public CloseArray As Variant
Public Sub OpenRecordset()
rst.CursorLocation = adUseClient
rst.Open "SELECT Field5 FROM " & MarketTableName & " WHERE Field1 BETWEEN " & stringStartDate & " AND " & stringEndDate & " ORDER BY Field1",
TIves
Last Activity: Jul 11 '12, 12:50 PM
Joined: May 25 '12
Location:
-
CopyMemory of a Variant holding an Array
Within a class module I open an ADODB recordset of a single field and then move it to a Variant with rst.GetRows
... -
How To Get External IP Address via VB/VBA
This uses HTML scraping of this site:
http://whatismyipaddre ss.com/
Code can be changed to work with other sites if you're comfortable with String manipulation
Paste this into a Module and run.
Cheers!
Trip
...Code:Private Declare Function URLDownloadToFile Lib "urlmon" Alias "URLDownloadToFileA" (ByVal pCaller As Long, ByVal szURL As String, ByVal
No activity results to display