TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...

Porting Excel/VBA into OpenOffice Calc

PDF document on what needed to import VBA from Excel into OpenOffice Calc Basic

Linkedin profle link

Have custom profile link to your LinkedIn profile If you are in tech for a ...

Run macro

Runs a macro from another workbook (Workbook has to be open).

Global asa

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

Import error log

Imports the SQL Server error log into a table, so that it can be queried This ...

DetectEmailServers

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

ChrW

Insert special characters inside Cell, using ChrW

ChartMaxY + ChartMinY

Calculates the maximum of the chart Y Axis to draw, the shifted one, not exact ...

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

Base64encode + Base64decode

Encodes and decodes a string, Base64 is used to convert binary data (like ...

Shapes-Macros

Read shapes in all worksheets in certain workbook and return list of macros ...

Shapes-Macros v1.0.xlsb.zip