On May 5, 1:18*am, "Peter T" <peter_t@discussions wrote:
"Subodh" wrote in message

news:1a132b94-d528-48e7-8efe-

Sorry Peter.
I meant the addin in the linkhttp://www.jkp-ads.com/articles/RegisterUDF00.asp
as mentioned above by Niek Otten
The advantage with this is that, it does not need any extra file (the
Dll file required in the case of Laurent's)
Or, as i said, it would also work if the dll file can also be attached
within the workbook in some way.

========================

You replied to Bernd's message but I can see the question is addressed to
me. The file in that link is not an addin, it's a demo xls.

It's not important where the data strings exist, cells on a sheet, hard
coded array or even read from file. The tricky part is to ensure you make
the command strings in the same way as shown in the demo code, and pay
particular attention to ensuring string data is embraced in double quotes
where necessary.

For my purposes I found the best approach was to thoroughly understand the
code, then remake it from scratch. You may find it can be simplified,
removing quite a lot of redundancy and speeding things up.

Regards,
Peter T

Thanks Peter.