ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel 2004 no longer supports SetData appleEvent (https://www.excelbanter.com/excel-programming/320747-excel-2004-no-longer-supports-setdata-appleevent.html)

SteveL

Excel 2004 no longer supports SetData appleEvent
 
We have an application that supports communication with Excel on both the
Mac, and Windows computers. The recent shake up in the Applescript model for
Extend 2004 has broken the communication with Excel. What we were doing,
which has worked for years, was just to send a setData appleevent from the
core events suite to excel, with a null parent. This defaulted to the active
worksheet, which was fine. This is not working any more in office 2004.
What I guess I am asking, is for a little information as to the simplest way
to set/get a value from a single cell in the default worksheet, and if there
is something that will work in excel 2004, and also in earlier versions.
Also, any ideas as to if there is some sample code anywhere would be helpful.
I've downloaded the applescript ref, but I want to keep things as simple as
possible, so I'm hoping to avoid as much of the object model as possible.
We are working in C++, and the code is as basic as it can be.
(AECreateEvent, AECreateDesc, and so on.)


All times are GMT +1. The time now is 01:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com