Search results 328

Sorted from new to old.

ANmaUploadFTP_ANstrFilesto1Folder

Upload all files found in ANStr list of files into 1 folder. Passing all ...

Aug7

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

QTexts_Min

Returns minimum quarter of 2 strings representing quarters, like 1Q2024, 3Q2015, ...

Jul27

UnicodeToChrW

Converts a unicode number into its ChrW text. It automatically uses surrogate ...

Jul17

DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

May30

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

May26

ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

May16

1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

May12

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

May1

ANmaUploadFTP_Script + ANmaUploadFTP_1File

Uploads 1 file to FTP. It will create temp script to login to FTP and uploads ...

Apr27

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

Apr10

1 2 ...20 21