Search results 64

Sorted from new to old.

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

2018Aug10

CellSave_Hyperlink

Creates a hyperlink to URL or to cell inside a cell in Excel VBA (or delete it). ...

2018Aug9

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

VB6Format

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

2018Jul24

LogFile_Add

Adds an entry to log file, if file is not exist, it will be created. Filename ...

2018Jul17

CreateZipFolder_7Zip

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

2018Jul14

NumberTextArabic

Adds Arabic unit to a number using proper Arabic grammar Units can be ...

2018Jun24

CellCommentRead + Save

Reads/Saves a comment into a cell CellCommentRead to Reads comment from a ...

2018Jun17

WorkbookOpen_ANmar

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

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

RemoveHTML

Removes HTML code Basically all tags expected and listed below There is a ...

2018May26

Calendar, a pure-VBA userform (FrmCal)

VBA pure Calendar form, no outside lib needed Edit 2020-03-18: Enhance ...

2018May16

SettingRead+SettingSave

This is the final version of my set of Setting functions SettingRead, ...

2018Apr27

ANStrList functions

Set of functions to manage ANStrList strings, read, save, delete, sort, compare, ...

2018Apr14

DB_SettingRead + DB_SettingSave + ...

Reads/Saves specific settings from DB table Mainly for Classic ASP, but can be ...

2018Apr14

1 2 3 4