Search results 59

Sorted from new to old.

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

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

Bootstrap 4 progress bars variables

Enhanced way to use progress bars in Bootstrap 4 Using below variable ...

2020Feb1

HasDups

Indicates if an array contains duplicate values. returns True if more than one ...

2019Oct5

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Screenshot_IrfanView

Saves a screenshot of the entire screen into a file using IrfanView (i_view32. ...

2019Jun27

1 2 3 4