• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Help me---Thank u
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Help me---Thank u


  • Subject: Re: Help me---Thank u
  • From: rhyme <email@hidden>
  • Date: Tue, 18 Dec 2001 10:30:56 +0100

Thank you very much !!
i have ms office 98, after your answer i've resolve my problem with this
string : Evaluate "macro.xls!compila()"
thanks

> Da: Paul Berkowitz <email@hidden>
> Data: Mon, 17 Dec 2001 23:24:16 -0800
> A: Applescript-Users <email@hidden>
> Oggetto: Re: Help me
>
> On 12/17/01 10:51 PM, "David Wignall" <email@hidden> wrote:
>
>> Create the VB macro as usual and then call it from your script with the line
>>
>> RunMacro "(MacroName)"
>>
>>> Thanks to all, bye !
>>
>> No worries. Hope I helped
>
> In Excel X there is no 'RunMacro' command in the Dictionary. Nor 'Do
> Script'. But 'Evaluate' is still there. I believe you still need the
> exclamation point after the Workbook path and before the macro name:
>
> Evaluate "WorkbookName!MacroName(value)"
>
> You can even get a result back if you've written the macro as a Function()
> rather than as a Sub(), which allows you to pass that 'value' parameter.
> (Otherwise, if it's a Sub and no result is needed, and no value inserted in
> the parentheses.)
>
> (There is a RunAutoMacros command, but that just applies to the four
> commands that can be automatically run at startup.)
>
>
> --
> Paul Berkowitz
> _______________________________________________
> applescript-users mailing list | email@hidden
> Help/Unsubscribe/Archives:
> http://www.lists.apple.com/mailman/listinfo/applescript-users
> Do not post admin requests to the list. They will be ignored.


  • Follow-Ups:
    • Re: Help me---Thank u
      • From: Craig Sutherland <email@hidden>
  • Prev by Date: COPY TO a list vs. SET TO a list
  • Next by Date: Re: AS Quality Assurance (was: Re: 9.2.2 Update effects onapplescript)
  • Previous by thread: Re: COPY TO a list vs. SET TO a list
  • Next by thread: Re: Help me---Thank u
  • Index(es):
    • Date
    • Thread