Hyperlink in Excel

[Gintaras]

Can register custom URL protocol to run QM macros.

Macro qm protocol register

Code:

Copy      Help

;Registers custom URL protocol to run QM macros.
;Then you can run QM macros from:
;;;Windows 'Run' dialog and some programs:  qm:macro name
;;;Hyperlinks:  <a href="qm:macro name">link text</a>


if(!IsUserAdmin) mes- "QM must be running as administrator." "" "x"
rset "URL:QM Protocol" "" "qm" HKEY_CLASSES_ROOT
rset "" "URL Protocol" "qm" HKEY_CLASSES_ROOT
rset "qmcl.exe M ''qm_protocol_handler'' C %1" "" "qm\shell\open\command" HKEY_CLASSES_ROOT

Function qm_protocol_handler

Code:

Copy      Help

str s=_command+3
s.escape(8) ;;sometimes command is urlencoded, eg from firefox
;out s
mac s
err+

-----------

Shows only 1 warning in Excel.
In web browsers, shows warning only first time.