Search results 60

Sorted from new to old.

ReNumber_IDColumn_inTable

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

2023Dec17

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

Excel user name

Get application user name or change it Originally from

2023Jun14

ScrapeURL_ToSheet

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

2023Apr4

JsBarcode

Generate barcode in js Tested and works better than others

2022Dec26

ANmaSQL_UpdateDateStatement

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

2022Jul4

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5

HTMLTagAttributeValue

Reads value of certain tag attribute from certain attribute Identify attribute ...

2021May30

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

2021Apr16

SumOf_3Filters

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

2021Jan29

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 3 4