In the days before Visual Basic for Applications, the macro language for Microsoft Excel was called XLL. The syntax was similar to that of ordinary Excel formulas, except for two things:

  • Macros were executed cell by cell until a =RETURN() or =HALT() statement.
  • XLL functions could have side-effects, like loading DLLs (REGISTER).

XLL has a documentation file called "macrofun.hlp", the presence of which in the correct location would reenable the XLL wizard until at least Excel 97. Trouble is, Microsoft have taken the downloads down and removed the online reference.

Is macrofun.hlp still available? How can I find it?

  • I tentatively tagged this documentation because I couldn't find a tag that fit. That could mean this question is off-topic! If there's a better tag, please let me know. – wizzwizz4 Oct 24 '18 at 8:11
  • 1
    @Raffzahn Sorry; I forgot how obscure this was! Is this better? – wizzwizz4 Oct 24 '18 at 10:38
  • To start with, I added application-program and programming. A new tag microsoft might be useful - not just for this one. – Raffzahn Oct 24 '18 at 10:50
  • @Raffzahn Yeah; I was thinking about microsoft. I'll add that one now. – wizzwizz4 Oct 24 '18 at 10:54

The help file is still available elsewhere on Microsoft’s site. The macrofun.exe file there is a self-extracting cabinet file containing macrofun.hlp, the table of contents (macrofun.cnt) and a README file with usage and installation instructions.

  • 3
    And it's no the least bit of fun, even if the name implies so... ;) – tofro Oct 24 '18 at 13:53
  • Link is offline – Albin Jun 10 '19 at 12:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.