Re: MS Excel 2004 XLL addin in xcode
Re: MS Excel 2004 XLL addin in xcode
- Subject: Re: MS Excel 2004 XLL addin in xcode
- From: Paul Berkowitz <email@hidden>
- Date: Sun, 13 Aug 2006 10:00:02 -0700
- Thread-topic: MS Excel 2004 XLL addin in xcode
Title: Re: MS Excel 2004 XLL addin in xcode
On 8/13/06 9:36 AM, "Jim McKinnon" <email@hidden> wrote:
I think I need to create a custom function like normal using VBA that somehow calls applescript, then unix script, then fortran/c code! I am researching applescript from VBA - but I have not found anything yet.
In VBA is a function called MacScript, which can execute any AppleScript (as a string). Look it up in the VBA Help. Literal quoting gets tricky, but it can all be done. One thing to look out for: multiline AppleScripts need to be first fed into a subroutine that replaces line endings with ' & vbCr & ' (vbCr is a useful VBA shorthand for carriage returns, used as line endings in VBA). You can call the Unix commands using 'do shell script' scripting addition within the AppleScript (see Standard Additions dictionary in Script Editor), which can do anything Unix. Quoting will now get very tricky...
--
Paul Berkowitz
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Xcode-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden