Office Excel 2008 and AppleScript

[Kaltsu]

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

 

[John McGhie]

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

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:[email protected]

 

[Michael Vilain]

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





--

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:[email protected]

So with the loss of Visual Basic on the MacOS X version of Excel,
there's still no viable scripting capability to replace it?

 

[JE McGimpsey]

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.

 

[Kaltsu]

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