Components 64 Controls, objects and classes, also cells, sheets, workbooks in VBA-Excel

Card image cap
a href=#

Instead of using href="#", it is better to use href="javascript:void(0);" to ...

Card image cap
Application_OnStart

How to use Global.asa

Card image cap
ConfigWeb_Read

Reads a key value from certain section in Config.web Originally from ...

Card image cap
SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

Card image cap
XLShortcut_EnableDisable

Disables or Enables certain Excel built-in shortcut. Code has example on how ...

Card image cap
Page2Setting

Read content of an html online page into setting value in Excel sheet. ...

Card image cap
SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Card image cap
CellSave_Hyperlink

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

Card image cap
FindFile_Word

Finds a file within open documents of current instance

Card image cap
WorkbookNew_ANmar

Creates new workbook (does not save it) and returns filename.

Card image cap
WorkbookClose_ANmar

Closes a workbook, checks if it is already open first, works for workbooks ...

Card image cap
List_Load + List_Save

Loads/Saves items from/to text file to/from listbox Also has simple adding and ...