Search results 202

Sorted from new to old.

ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

2023Apr7

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

SQL Related posts

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

2022Jul6

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

DBTables

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

2022Apr28

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

CSVs2Sheets

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

2021Oct5

tag_add

Add to textbox from listbox (select option) ensure its uniqueness Needs ...

2021Aug24

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

setSelectedIndex byname and byval

Set active (Selected) item in listbox using javascript Imported and modified ...

2021Jun10

1 2 ...5 ...12 13