Search results 30

Sorted from new to old.

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

RemoveSignWord

Removes the WordTemplate [Sign-Head-????] from FromStr and returns whatever ...

2024Jul15

SQL Cross Apply String_Split with XML Path

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

2024Jan20

SettingRead_Ajax + SettingRead_Ajax_IntoObject

Two functions to return an output of file into object on page or back to caller ...

2024Jan12

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1

ScrapeURL_ToSheet

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

2023Apr4

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

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

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

ANC Bootstrap controls (Testing < and & # 6 0 ;)

Testing step in site (or in each HTML output function to replace < with < ...

2021Jun9

Bootstrap Editable Table

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

2020Oct6

JSON-VBA

2 modules to read output of json API (or file) into parsed array of objects. ...

2020Jul30

1 2