Search results 59

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Card image cap
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Card image cap
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

Card image cap
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image cap
ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

Card image cap
Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

Card image cap
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Card image cap
Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

Card image cap
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...