Search results 181

  2. Search results
  3. old
Sorted from new to old.
Card image
RunFromTemp

Check if an Excel file is running from 'Temp' location or regular folder This ...

2018Jun17
Card image
EnvVar_All

Read all Environment variables using EnvDir_All Or quickly get user folder, or ...

2018Jun17
Card image
File_MostRecent

Getting most recent file in a folder

2018Jun16
Card image
BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16
Card image
HardDrivePartitionSN

Get Hard drive SN (old fashioned way) using FileSystemObject

2018Jun15
Card image
BrowseFolder

Asks user for a folder tested in VBA of word as well as VBA in Excel

2018Jun14
Card image
OpenPassword + ClosePassword

Encrypt / Decrypt a string, convert it to "77 96 105 105 106" or back to ...

2018Jun14
Card image
FixPath, IsThere, IsThere1 ...

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

2018Jun11
Card image
Filesin_Coll + Filesin_Cells

Reads files in a specified folder into a Collection, work with VB6 and VBA also, ...

2018Jun10
Card image
FindIn1DArray

Returns 1 if an item found in array, 0 if not

2018Jun6
Card image
Paragraph2Line + Line2Paragraph

Converts paragraph to 1 line text or 1 line text to paragraph Mainly used to ...

2018Jun2
Card image
GetPapa, GetPapa_URL, GetPapa_Sep, GetSon, GetSon_

Gets that parent folder name giving a full path, or gets the child folder, Can ...

2018May22
Card image
FilesIn + FilesIn_Count

Returns list of files found in a folder, list separated with custom separator ...

2018May22
Card image
FrmLarge v3

Shows an image after clicking on its thumbnail, like in web applications Can ...

2018May20
Card image
IsThere1

Finds out if a file exists, can pass either mapped file path, or unmapped

2018Apr25
Card image
FileSize_Formatted

Returns file size in formated human way (mb, gb, etc..) Or, it can format any ...

2018Apr25
12...1112