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

Card image cap
Global asa

As ASP Classic user, I have to have some post about global.asa Here is one, ...

Card image cap
SendEmail_CDO

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

Card image cap
ArrSort_2Arr

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

Card image cap
UserIP

Reads the website visitor IP

Card image cap
DetectEmailServers

Detects mail servers available by returning number of available mail servers ...

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