Beefy Boxes and Bandwidth Generously Provided by pair Networks
We don't bite newbies here... much
 
PerlMonks  

Re: Re: How some people live without Perl

by runrig (Abbot)
on Mar 07, 2003 at 00:17 UTC ( #241041=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://241041]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (2)
As of 2022-01-18 08:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (52 votes). Check out past polls.

    Notices?