Thread
:
fields queries and utter disaster
View Single Post
#
28
Posted to microsoft.public.mac.office.word,microsoft.public.word.mailmerge.fields
Paul Berkowitz
Posts: n/a
fields queries and utter disaster
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.
Reply With Quote