Re: Help me---Thank u
Re: Help me---Thank u
- Subject: Re: Help me---Thank u
- From: Craig Sutherland <email@hidden>
- Date: Tue, 18 Dec 2001 08:45:18 -0600
I have bad news. I just received notice from MS-
*********
Craig -
Well I found the answer but afraid it's not good news for now.
Looks like there is a bug in this version - macros cannot be run from
applescript.
The issue has been placed on the fix list for a service release.
I cannot tell you when it will be done, the tenative time is late 1st
quarter or early second quarter
next year.
This issue as has been set so as not to decrement you support issues.
Thanks,
Jon Barchenger
Macintosh Office/Excel Tl
****
Craig
On Tuesday, December 18, 2001, at 03:30 AM, rhyme wrote:
>
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.
>
_______________________________________________
>
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.