Solved: Excel Macro laguage 4

[cleturno]

Does anyone know anything about this language. I am trying to understand the two procedures, but some of the calls don't make any sense to me at all. If anyone could give me a little help with this it would be greatly appreciated. I have just never dealt with this syntax.

Thanks,
Chris

[OBP]

Can you post it on here so that we can see the code please?

[Emily]

To display help topics for Microsoft Excel 4.0 macro functions, you must first install the complete Macro Function help file (Macrofun.hlp).


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

[cleturno]

Here is the source that I am refering to, I am just not familar with this syntax and Microsoft's help files only work for office 2000 or lower and I am running 2003. So I am feeling around in the dark here for some type of syntax relation table between XML4 and VBA. Any thoughts??

[cleturno]

If anyone even has the help file and they can copy it into a word doc they would be a savior. I don't have any type of reference whatever to go by. Thanks for any and all help in advance.

[Norie]

Chris

Why don't you try and work/find out the purpose of the code?

That might help you decipher it.

[Bob Phillips]

You can debug them in a similar manner as VBA, just select the macro from the macro list and step into. You don't get tyhe VBIDE, but a dialog box which shows the line to be executed.

[Norie]

xld

I've tried debugging but it doesn't get past the first IF.

=IF(AND((GET.CELL(3)=29),(GET.CELL(2)>212),(GET.CELL(2)<(213+!N208))))

What I think this is saying is if the active cell is in column 29 and between row 213 and 227 continue with the code.
=IF(AND((GET.CELL(3)=29),(GET.CELL(2)>212),(GET.CELL(2)<(213+!N208))))

[Bob Phillips]

Norie,

In that test, the limits of the test are greater than row 212 (which you can easily see), and less than 213 AND the value in N208. So if N208 is empty, it will test >212 and <213, which will force an exit. Run it from AC214, with 5 in N208, and watch it work.

[cleturno]

The purpose of the code is to take an enormous spread sheet and run trials based off of that sheet to figure out when a maximum is reached in the sequence. The number of cases is based upon the user input on another sheet. I am not that good at VBA or I would be trying to figure it out. I don't have any references for the functions or syntax. I don't want someone to do it for me all I want is some way to reference the built in functions.

[Norie]

Chris

Are you sure you can't download and open the help file from the link that emily provided?

It isn't an Office help file in the first place, you should just be able to download and open it from the desktop, rather than from within Excel.

Try that, there's even a section on the VBA equivalents.

By the way it isn't VBA code anyway.

[cleturno]

I know that it isn;t VBA code it is Excel MAcro 4. I am trying to convert it over and I didn't have a syntax reference. I missed the post from emily, I got drawn into the discussion further down.

Thanks for the help Emily that file saved me.