Search results 67

Sorted from new to old.

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

Embed fonts in Word doc

Embed fonts used in document, to make it available on any machine

2019Jan7

Wordpress drop-down menu

Add dropdown with User login, logout into menu. This code used to replace "nav. ...

2018Dec18

Listbox height changing issue

Listbox in Excel sometimes have issue adjusting height to items added inside, ...

2018Aug25

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

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

1 2 3 4 5