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
Private sc As New ScriptControl
Public Function uc(txt As String) As String
sc.Language = "PerlScript"
uc = sc.Eval("uc(" & txt & ")")
Now you can type =uc("hello") in your spreadsheet to call the above fu
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.
Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big>
<blockquote> <br /> <dd>
<dl> <dt> <em> <font>
<h1> <h2> <h3> <h4>
<h5> <h6> <hr /> <i>
<li> <nbsp> <ol> <p>
<small> <strike> <strong>
<sub> <sup> <table>
<td> <th> <tr> <tt>
Snippets of code should be wrapped in
<code> tags not
<pre> tags. In fact, <pre>
tags should generally be avoided. If they must
be used, extreme care should be
taken to ensure that their contents do not
have long lines (<70 chars), in order to prevent
horizontal scrolling (and possible janitor
Want more info? How to link or
or How to display code and escape characters
are good places to start.