REGISTER.ID function
REGISTER.ID registers an external routine and returns an ID that CALL can use to run it. It is a legacy Excel 4 macro-sheet function that works on Windows only and is often blocked.
Example
=REGISTER.ID("Kernel32","GetTickCount","J")
Expected result: n/a Not yet checked in desktop Excel
Syntax
REGISTER.ID(module_text, procedure, [type_text])
Arguments in [square brackets] are optional.
-
module_text(required) - Name of the DLL or code resource.
-
procedure(required) - Name of the function inside it.
-
type_text(optional) - Codes describing the argument and return types.
Returns: A registration ID to pass to CALL.
Watch out for
- Returns #VALUE! if the DLL or routine is not found.
Where it works
- Excel
- REGISTER.ID is in every version of Excel from 2007 on. Legacy Excel 4 macro function; Windows only and often blocked.
- Google Sheets
- No direct equivalent. No counterpart.
Part of Add-in and automation functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .