Re: Help me---Thank u
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.