Components 194

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

Sorted from new to old.

SendEmail_CDO

Sending an email using CDO object Can pass all needed variables including mail ...

2018Nov24

ArrSort_2Arr

Sort 2 1-dimension arrays Actually sort 1st array (Array1) based on values ...

2018Oct1

UserIP

Reads the website visitor IP

2018Sep27

a href=#

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

2018Sep12

Application_OnStart

How to use Global.asa

2018Sep5

ConfigWeb_Read

Reads a key value from certain section in Web.config Originally from ...

2018Sep5

SheetName

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

2018Aug23

XLShortcut_EnableDisable

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

2018Aug16

Page2Setting

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

2018Aug12

SheetDelete_ANmar

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

2018Aug9

CellSave_Hyperlink

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

2018Aug9

FindFile_Word

Finds a file within open documents of current instance

2018Aug9

WorkbookNew_ANmar

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

2018Aug9

WorkbookClose_ANmar

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

2018Aug9

List_Load + List_Save

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

2018Jul26

sortArray

Sort an array of Numeric values, simple straightforward Edit v3 2021-09-21: ...

2018Jul25

1 2 ...9 ...12 13