The Visual LISP Developer's Bible - 2003 Edition

The undocumented trick consists simply in calling the XLM function SET.NAME in the VBA module with the ExecuteExcel4Macro method : Creating A Hidden Name To create a hidden name named Test, containing the string "OK", use Application.ExecuteExcel4Macro "SET.NAME(""Test"",""OK"")" Retrieving The Contents Of A Hidden Name To retrieve the contents ... ................
................