Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
'Retrieve record from SQL Server Set cnt = New ADODB.Connection stADO = "Provider=SQLOLEDB.1;" & _ "Data Source=xxxx;Initial Catalog=Dynamics_BAK;User ID=report;Password=123" With cnt .CursorLocation = adUseClient .Open stADO .CommandTimeout = 0 End With 'SQL Statement stSQL = "select * from WMSORDERTRANS where SHIPMENTID = 'A10009480' order by linenum" Set rst = cnt.Execute(stSQL) If rst.RecordCount <> 0 Then rst.MoveFirst Do MsgBox rst("itemid") rst.MoveNext Loop Until rst.EOF rst.Close End If
|Excel bubble chart with most common ranges of values||12||41|
|Automatically report prepared in excel by VBA||5||34|
|transition to visual .net from vb6||5||37|
|Conditional formatting of a cell based on text anywhere in the workbook||4||51|