 |
|
|
|
Next: 5.1.1 Not our customer
|
| Author |
Message |
External
Since: Nov 01, 2009
Posts: 2
|
(Msg. 1) Posted: Sun Nov 01, 2009 10:51 am
Post subject: Office Excel 2008 and AppleScript
Archived from groups: microsoft>public>mac>office>excel (more info?)
|
|
|
Hey,
Is it possible to call AppleScript when changing cell value in Office
2008 Excel? I try to migrate some xls files but there sould be some
kind of automation still available...?
Tomi |
|
| Back to top |
|
 | |
External
Since: Jul 28, 2007
Posts: 1803
|
(Msg. 2) Posted: Sun Nov 01, 2009 9:20 pm
Post subject: Re: Office Excel 2008 and AppleScript [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
Realistically, "No".
AppleScript cannot respond to Excel events, so the Cell on_change event is
not available to Applescript.
With a LOT of coding, you might be able to work around this, but I don't
think the effort involved would be worth it.
Hope this helps
On 2/11/09 5:51 AM, in article
7a238814-a06f-41f4-bdd4-37231d8e859d.DeleteThis@g27g2000yqn.googlegroups.com, "Kaltsu"
<kaltsug.DeleteThis@gmail.com> wrote:
> Hey,
>
> Is it possible to call AppleScript when changing cell value in Office
> 2008 Excel? I try to migrate some xls files but there sould be some
> kind of automation still available...?
>
> Tomi
--
This email is my business email -- Please do not email me about forum
matters unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:john@mcghie.name |
|
| Back to top |
|
| |
External
Since: Nov 04, 2007
Posts: 190
|
(Msg. 3) Posted: Sun Nov 01, 2009 9:20 pm
Post subject: Re: Office Excel 2008 and AppleScript [Login to view extended thread Info.]
Imported from groups: per prev. post (more info?)
|
|
|
[[This message is not archived, and is only displayed for one month past post date.]]
In article <C714916F.38C4%john@mcghie.name>,
John McGhie <john DeleteThis @mcghie.name> wrote:
> Realistically, "No".
>
> AppleScript cannot respond to Excel events, so the Cell on_change event is
> not available to Applescript.
>
> With a LOT of coding, you might be able to work around this, but I don't
> think the effort involved would be worth it.
>
> Hope this helps
>
>
> On 2/11/09 5:51 AM, in article
> 7a238814-a06f-41f4-bdd4-37231d8e859d DeleteThis @g27g2000yqn.googlegroups.com, "Kaltsu"
> <kaltsug DeleteThis @gmail.com> wrote:
>
> > Hey,
> >
> > Is it possible to call AppleScript when changing cell value in Office
> > 2008 Excel? I try to migrate some xls files but there sould be some
> > kind of automation still available...?
> >
> > Tomi
>
>
> --
>
> This email is my business email -- Please do not email me about forum
> matters unless you intend to pay!
>
> John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
> McGhie Information Engineering Pty Ltd
> Sydney, Australia. | Ph: +61 (0)4 1209 1410
> +61 4 1209 1410, mailto:john@mcghie.name
So with the loss of Visual Basic on the MacOS X version of Excel,
there's still no viable scripting capability to replace it?
--
DeeDee, don't press that button! DeeDee! NO! Dee...
[I filter all Goggle Groups posts, so any reply may be automatically by ignored] |
|
| Back to top |
|
| |
External
Since: Mar 27, 2004
Posts: 4559
|
(Msg. 4) Posted: Sun Nov 01, 2009 9:20 pm
Post subject: Re: Office Excel 2008 and AppleScript [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
In article <vilain-16DA75.18524001112009.RemoveThis@individual.net>,
Michael Vilain <vilain.RemoveThis@NOspamcop.net> wrote:
> So with the loss of Visual Basic on the MacOS X version of Excel,
> there's still no viable scripting capability to replace it?
Depends on what you decide "viable" means.
The vast majority of my common XL04 macros work as AppleScripts. The
process of coding them in AS wasn't exactly easy, but that's probably
due more to my 20+ years of programming prejudices than AS.
If one needs to respond to events (about 0.01% of my clients), you're
SOL with AppleScript, but fine when staying with XL04, and will
(presumably) be better than ever when MacXLNext comes out. |
|
| Back to top |
|
| |
External
Since: Nov 01, 2009
Posts: 2
|
(Msg. 5) Posted: Tue Nov 03, 2009 12:45 am
Post subject: Re: Office Excel 2008 and AppleScript [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
|
|
|
On 2 marras, 04:38, John McGhie <j....TakeThisOut@mcghie.name> wrote:
> Realistically, "No".
>
> AppleScript cannot respond to Excel events, so the Cell on_change event is
> not available to Applescript.
>
> With a LOT of coding, you might be able to work around this, but I don't
> think the effort involved would be worth it.
Ok, thanks John. We'll have to run AppleScript then externally or use
these few files with Windows.
Tomi |
|
| Back to top |
|
| |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
Mac