Excel_Lib on Mac

[Bob Sneidar]

Matthia you are a genius. This apparently is a bug in the most recent version of Livecode. I tried you method, and now ALL versions of Livecode have access to send apple events to Excel. 

Bob S


> On Mar 16, 2022, at 08:18 , Bob Sneidar via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> I have older versions of Livecde still, I should give that a try. I wonder what happens then when I use it in a compiled app? We shall see. 
> 
> Bob S
> 
> 
>> On Mar 16, 2022, at 05:35 , matthias rebbe via use-livecode <use-livecode at lists.runrev.com> wrote:
>> 
>> I tried with a sample stack here with Livecode 10 and had the exact problem.
>> 
>> I then tried Livecode 9.6.3 and got a macOS system pop up with the following message
>> LiveCode Business 9.6.3.app“ möchte Zugriffsrechte, um „Microsoft Excel.app“ zu steuern. Durch die Erlaubnis zum Steuern kann auf Dokumente und Daten in „Microsoft Excel.app“ zugegriffen werden und Aktionen können in dieser App durchgeführt werden.
>> 
>> something like this in English:
>> Livecode Business... wants to have access rights to control Microsfot Excel app. By granting access documents and data in Microsoft Excel.app can be accessed and actions can be done.
>> 
>> After confirming/allowing  Livecode was listed under Automation in System Preferences -> Security
>> 
>> And the funny part of this is, that not LC 9.6.3 is listed now under Automation, but LC 10 DP2. 
>> 
>> I tested then with 9.6.3 and with 10DP and it works now in both editions.
>> 
>> 
>> Matthias
>> 
>> 
>> 
>> 
>> 
>>> Am 15.03.2022 um 22:50 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
>>> 
>>> Hi all. 
>>> 
>>> I am trying to incorporate Excel_Lib into a project. There is a command to open a spreadsheet with Excel on a Mac, and ONLY Macs can use this command. It looks however like the library works with Windows too. 
>>> 
>>> My issue is that I am getting an error, "XCELLibErr: Not authorized to send Apple events to Microsoft Excel." So first, is there an easy way, like a shell command to do this? And then if not, is using this library dependent on Apple events on a Mac? 
>>> 
>>> Bob S
>>> 
>>> _______________________________________________
>>> use-livecode mailing list
>>> use-livecode at lists.runrev.com
>>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>>> http://lists.runrev.com/mailman/listinfo/use-livecode
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode