Search results 96

Sorted from new to old.

DB Functions (By AI)

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

2023Apr23

Arabic in MySQL

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

2023Apr12

ScrapeURL_ToSheet

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

2023Apr4

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Bootstrap Editable Table

Editable table with Bootstrap 4, with multiple controls, having: Checkbox for ...

2020Oct6

1 2 3 ...5 6