Search results 152

Sorted from new to old.

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Filename_Clean

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

2023Jan11

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Shape_Select_or_CreateThenSelect

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

2022Jul21

Frm5Textbox

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

2022Feb22

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

2022Jan28

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

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

2021Nov26

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Frm81 - FullDetails

Show window of details, can be used to show content for certain cell, or show ...

2021Jun26

1 2 ...4 ...9 10