Microsoft Office Word Forum - WordBanter - View Single Post

On 5/4/06 10:08 PM, in article
, "consiglieri"
wrote:

Aha..didnt know VBA could execute perl scripts.Thats good news I think.

What the VBA is doing there is a 'MacScript' command, which is an
AppleScript as a literal string. The AppleScript in turn is calling 'do
shell script', a command which can run any Unix shell script (also as a
string). The quoting can get a bit hairy. Quotes within quotes in VBA are
doubled. POSIX File paths within 'do shell script' AppleScript should use
the

quoted form of POSIX path of [colon-file-path]

if it's got any spaces in the file path, anywhere. or it gets too hot to
handle.

Can you recommend a good tutorial for VBA on the net ...where they have
some kind of example that helps you get going?

You won't find any AppleScript/MacScript guidance anywhere, mind you. You
need to know some AppleScript and then the VBA Help's simple description of
MacScript is all there is.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: http://www.entourage.mvps.org/faq/index.html
AppleScripts for Entourage: http://macscripter.net/scriptbuilders/

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.