Search results 47

Sorted from new to old.
Card image
IsEven + IsOdd

Returns True if integer is even by using IsEven While IsOdd, will returns True ...

Card image
PrettyPath

Formats a path for use in user displays, trim it beautifully. PrettyPath is ...

Card image
IsValidUTF8 + DecodeUTF8 + EncodeUTF8

Checks UTF8, or convert to/from UTF8. Simple functions to convert the first 256 ...

Card image
DigitsORLettersOnly

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

Card image
IIF

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

Card image
DownloadFile_User

Downloads file to user, asking user where to save or to open downloaded file

Card image
CanAccessVBA

Returns true if VBA is accessible through code, returns false if not

Card image
AreTheyTheSame

Compares between two files in binary mode and returns true if they are ...

Card image
ScreenRes

Reads screen resolution, using IE this time, this one will get the active ...

Card image
WorkbookOpen_ANmar

Opens Workbook without running AutoMacros and without letting the user know ...

Card image
GetColumnName, ColumnName_XOffset

Gets the column name from a cell address. Returns "E" from "E45", or "BR" from ...

Card image
FixPath, IsThere, IsThere1 ...

Set of 6 functions to deal with filesystem. Gets current workbook path, ...

Card image
FindName

Finds a name in a workbook, returns true or false

Card image
FindSheet

Finds a sheet in a workbook, if no workbook name passed, it will use ...

Card image
File Upload

Uploads a file to the server