saviourofdp
saviourofdp
/ ado.vbs
Last active
November 7, 2017 09:09
Using HTML Table as a Datasource in VBScript
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| dim ado, rs | |
| set ado = CreateObject("ADODB.Connection") | |
| ' also works with the older Jet driver | |
| 'ado.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=table.html;Extended Properties=""HTML Import;HDR=NO;"";" | |
| ado.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=table.html;Extended Properties=""HTML Import;HDR=NO;"";" | |
| set rs = ado.Execute("SELECT F2 FROM [table] WHERE F1 = 'Selling Price'") | |
| WScript.Echo rs.GetString(2,,vbTab, vbNewLine) |
saviourofdp
/ gist:722a8bd7c95a093c8ee6
Last active
August 29, 2015 14:08
This is just a test, showing some HTML and a description
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html> | |
| <html> | |
| <head></head> | |
| <body>test</body> | |
| </html> |