Search results 576

Sorted from new to old.

ExtractNumeric_FromCell

Returns the number from an HTML cell after cleaning and finding sign. We faced ...

Aug6

StartApp-IfNotStarted

Checks if application is already running, returns 1 or 0 My first function

Aug3

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

Jul28

DownloadFile_Safe

Downloading file directly to machine without refreshing or going to another ...

Jul27

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

RemoveSignWord

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

Jul15

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

CutString97

Cuts part from large string from certain character to certain character with ...

Jun5

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

Jun1

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

1 2 ...35 36