XLM Macro Language

I still have Excel4 Function Reference book, among others, would you believe (and a working version of Excel 5).

Interestingly the old versions of Word & Excel run OK from copied files/folders (no need to install after the first time. no registry or win.ini entries). We get prompted for missing .dll's the first time, these can be found and copied to the main folder.

I still use an old Word2 document containing macros that do look ups in a set of documents that I have not had to change or upgrade (thank heaven).

In answer to your query, if you go here you can download macrofun.exe which is the zipped macro help file which runs on its own. If you have problems I can email a copy ( PM me your address). I have just opened it via winzip without problem. I don't think it looks for Excel because, although I use XL2000 the old version is not registered anywhere.

http://support.microsoft.com/kb/128185

BrianB - if OP runs version beyond XL2000 it won't open - I think this is inferred in the initial post.

(I'd like to get my hands on it myself )

EDIT: in response to above post Edit - see: http://www.microsoft.com/downloads/...6b-7485-437a-819b-0f446f74ed81&DisplayLang=en
OS would appear to be determining factor

Hmm... I am able to open the .hlp file direct without issue - thanks BrianB!

Using XP pro & Windows 7....... works Ok too.

BrianB, DonkeyOte,

Perfect, just what i was looking for - Thank you both very much.

Regards,

Pete

A year late to this party but couldn't avoid chiming in as the 2nd Brian B on the thread and with a similar question about my continuing search for some decoupled help/glossary file for xlm language.

I'm running on a Mac so none of the linked files in this thread will help. I'm not necessarily looking for a file that can be reached by clicking the help tab in Excel. A .pdf or .doc or webaddress or whatever would be handy.

Meanwhile Problem of the moment is I can't find the right syntax to get the macro to change workbooks.

The only reference I have is for Excel 2.2 which i think is before there were files with multiple worksheets. So the reference talks about changing worksheets but I think that would be the equivalent of changing workbooks nowadays.

In any event, after some digging I find that the manual says all you have to do is name the worksheet followed by an exclamation point before the reference. I'm trying to use the SELECT() function although all the examples I find in the manual are FORMULA.GOTO()

the syntax examples they call out are

=FORMULA.GOTO(Worksheet1!A1)
or
=FORMULA.GOTO("Worksheet1!R1C1")

I've tried both styles of references with SELECT and FORMULA.GOTO to move to an open document. I tried substituting both the name of the workbook and the name of the worksheet within the workbook and putting them together separated by a period and then gave up and hit the internet.

I'm running 2004 on a Mac.

Thanks,

Brian B

Use the ACTIVATE function, to activate the window with the required workbook.

If you are running 2004, can you not use VBA instead of XLM? (Or do you need compatibility with 2008?)

GlennUK said:

Use the ACTIVATE function, to activate the window with the required workbook.

Click to expand...

Glenn,

that's the trick. references that are rejected in the SELECT and GOTO function work fine in ACTIVATE. I don't get why but that problem solved.

If you're still watching, here's the next one. What is the command for SELECT.ALL() just made that up, or maybe SELECT(All) or . . . ? since neither of those works. On my Mac that is a function accessed with the command and A key.

What I'm trying to do is quickly select all the cells with entries in a worksheet and reformat them using the FORMAT.FONT function to a different font and font size.

thanks,

brian