SpreadCE / Spread32

This is my first try out of Spread32 and SpreadCE.
I'm developing the macros on the windows x86 version before moving it to WinCE.

on the win32 version

=ALERT(mysearch) gives me a macro error if "mysearch" contains alpha characters. Numeric only is ok.

code:

=SET.NAME("mysearch",INPUT("StockCode",1,"Input Stock Code"))
=ALERT(mysearch)
=RETURN()

I haven't tried it under wince yet.

What am I missing here ?

Hi Mark,

The Win32 and WinCE versions of the software are the same, so if something works on one then it will work on the other.

The second parameter of the INPUT function specifies the type of value it is expecting, according to this list:
0 formula
1 number
2 text
4 logical
8 reference
16 error
64 array
If your input value will be text then you need to use 2 instead of 1.

If your input value could be a number or text, then you could specify a value of 3 (which is 1+2) and the program should convert the input value to either a number or text as appropriate.
However, there is a problem with the program, and if you do specify a value of 3, it will always try to convert the input value to a number.
I am working on fixing this right now, but in the meantime if you change the 1 to a 2 in the Input formula then it should work correctly.

Hi Stephen,

Unfortunately the input will be mixed text and numbers, with either one first.

No doubt this could produce interesting output.

I'll wait for the fix.

Many thanks,

Mark.

But if they arer stock codes, wouldn't you want the values to be always treated as text, even if they contain only digits?

Yes, for this task the input would be treated as text regardless.

Using 2 solves the problem.

This is ancient stuff, I haven't used excel macros for many years, and I mainly used Lotus123 in those days.

Have you found any useful references on (old) macros ?
Most references to macros I found are actually VBA, which I am much more familiar with.

Thanks.

I don't know of any books on the Excel4 macro language, but you can download Microsoft's reference file for it from here:
http://support.microsoft.com/kb/143466

Thanks, that was useful, but lacks acurate examples.

After some hunting, I found a full Excel 4 here.
http://www.vetusware.com/category/Office/?cat=4&page=3
It has macro application examples and will be useful for initial developing on.
It even runs happily on XP.