Search results 127

Sorted from new to old.
Card image
WorkbookOpenAsk_ANmar

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

Card image
getDaysInMonth

Gets number of days in a certain month

Card image
CreateZipFile_7Zip

Compress a single file into zip archive using 7Za.exe 7za.exe (found in ...

Card image
CreateZipFiles_7Zip

Create zip from list of files listed in List_of_Files separated by comma. The ...

Card image
CreateZipFolder_7Zip

Creates a zip from folder using 7Z archive. 7za.exe (found in attached zip) ...

Card image
FileDateTime

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

Card image
ServerVar

Get value of Server variable by passing variable name aVar can be any of these ...

Card image
Capitalize

This function capitalizes first letter of each of the words in a sentence, ...

Card image
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

Card image
FS_CopyFile

Copies a file

Card image
IsFolder

Returns a Boolean value that indicates if the parameter is a folder.

Card image
DirsCombo_Read

Read directories in a specified folder into a combobox Needs FrmBr having Cbo1

Card image
CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...

Card image
File_MostRecent

Getting most recent file in a folder

Card image
BrowseWorkbook + BrowseWorkbook_Save

Asks for Excel file to open, then return the full filename with path if ...

Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject