http://qs321.pair.com?node_id=241041


in reply to Re: How some people live without Perl
in thread How some people live without Perl

One of my great regrets is that you cant use Perl as Excels macro language.
But you can...

Update: I'm posting the text of that link here, because I think its valuable to have in more than one place:

If you haven't got the Microsoft Script Control, download it from some +where in http://msdn.microsoft.com/scripting [microsoft.com]. Then in Excel, set Tools - References - Microsoft Script Control. In your code, you can now eval and execute Perl code, and use it in an +y Functions that you've declared as public - here's a trivial example +: Option Explicit Private sc As New ScriptControl Public Function uc(txt As String) As String sc.Language = "PerlScript" uc = sc.Eval("uc(" & txt & ")") End Function Now you can type =uc("hello") in your spreadsheet to call the above fu +nction. You can even use modules; I had an example using Lingua::EN::Numbers, +but I can't lay my hands on it at the moment. Hope this helps.