Search results 59

Sorted from new to old.

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

2023Jul9

Excel user name

Get application user name or change it Originally from

2023Jun14

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

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

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Old cell value

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

2021Dec30

HTMLTagAttributeValue

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

2021May30

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

1 2 3 4