Search results 207

Sorted from new to old.

WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

2018Aug9

DigitsORLettersOnly

Check if the string has special characters or not, only Letters or digits ...

2018Aug8

UserSign

Returns someones astrology sign using their birthday in m/dd/yyyy or m/dd/yy ...

2018Aug8

FoldersIn

Returns list of folders found in given folder in a string in ANStr format, ...

2018Aug3

Posts_per_Year

Gets list of years and total of posts per year from a table, by using date ...

2018Jul29

RandomRecords

Returns random IDs (or any column) from SQL Database table, passing number of ...

2018Jul29

CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

DB_SettingRead_Field

Returns a certain field from Settings table by a SettingName. Similar to ...

2018Jul24

GetRelativePath

Get relative path of one to another Pass two path strings to this function and ...

2018Jul19

WorkbookSaveAsk_ANmar

Asks user to save file (or workbook) using GetSaveAsFilename method. Returns ...

2018Jul17

WorkbookOpenAsk_ANmar

Asks user to browse to a file and return full path and file name if they do, ...

2018Jul17

MP3GetInfo

Returning information on an MP3 file. Returns a type containing information ...

2018Jul11

ServerUptime

Return how long the computer has been running. Return format is dd:hh:mm:ss ...

2018Jul11

SplitTo2DArray

Splits ANStrArray into 2-Dimension array Using custom row and column ...

2018Jul9

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

2018Jul9

IIF

Works the same as it's VB IIF equivalent. IIf will coerce an expression into ...

2018Jul7

1 2 ...10 ...12 13