Search results 82

Sorted from new to old.

VB6Format

Trying to create VB6 "Format" function in Classic ASP, works now for date only, ...

2018Jul24

URLs2Anchors

All links found inside a string into anchor (< a href=...) BUG!: Currently ...

2018Jul17

WorkbookSaveAsk_ANmar

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

2018Jul17

WorkbookOpenAsk_ANmar

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

2018Jul17

CreateZipFile_7Zip

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

2018Jul14

CreateZipFolder_7Zip

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

2018Jul14

FixENTERS_File

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

2018Jul7

Import_CSV

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

2018Jul7

Ordinal

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

2018Jun24

DirsCombo_Read

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

2018Jun18

File_MostRecent

Getting most recent file in a folder

2018Jun16

BrowseWorkbook + BrowseWorkbook_Save

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

2018Jun16

FixPath, IsThere, IsThere1 ...

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

2018Jun11

Filesin_Coll + Filesin_Cells

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

2018Jun10

RoundUp

Rounds a number up, like Excel function RoundUP

2018Jun2

CutString

Cuts a string from certain char till certain char, can be used to cut left, ...

2018May29

1 2 ...5 6