Search results 247

Sorted from new to old.
Card image
GetRelativePath

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

Card image
WorkbookSaveAsk_ANmar

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

Card image
WorkbookOpenAsk_ANmar

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

Card image
MP3GetInfo

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

Card image
ServerUptime

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

Card image
SplitTo2DArray

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

Card image
Shapes-Macros

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

Card image
IIF

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

Card image
FixENTERS_File

Removes [Enter]s from imported csv file into Excel worksheet. Smart enough to ...

Card image
oShellRun1

Runs a WScript.Shell command with wait until finish and returns 0, 1, 2 or -1 ...

Card image
FileDateTime

Gets time and date for a file, Date created, accessed or modified. If the file ...

Card image
PI

Returns a double representing the mathematical constant Pi

Card image
GetTempFileName

Returns temp file name using FSO

Card image
RandomArray

Creates array of random numbers, returns 1 Dim array

Card image
Distance_Calc_fromString

Calculate distance between two points (Latitude, Longitude) LatLon1 and ...

Card image
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...