Search results 105

  2. Search results
  3. fix
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, ...

2018Jul17
Card image
CreateZipFile_7Zip

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

2018Jul14
Card image
CreateZipFiles_7Zip

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

2018Jul14
Card image
CreateZipFolder_7Zip

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

2018Jul14
Card image
SplitTo2DArray

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

2018Jul9
Card image
IIF

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

2018Jul7
Card image
FixENTERS_File

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

2018Jul7
Card image
Import_CSV

Import the CSV file, DOES NOT OPEN, Open does not fix encoding issue, import ...

2018Jul7
Card image
Ordinal

Get a Number Suffix They allow you to turn 1 into 1st, 2 into 2nd, etc. giving ...

2018Jun24
Card image
DirsCombo_Read

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

2018Jun18
Card image
HaveNonEnglish + StringASCIIs

Checks if one char is within two ASCII codes or not (StringASCIIs) Used to see ...

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
FixPath, IsThere, IsThere1 ...

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

2018Jun11
12...67