Re: ExcelLib in a standalone
> Am 23.03.2022 um 00:14 schrieb Bob Sneidar via use-livecode > : > > Oh yes, that is what I read. Got my wires crossed. > > It's interesting that you found that Excel was running hidden. My hangups in > the past may just have been that I was getting some kind of dialog but > couldn't see it because the app was hidden. I say that because when I tried > to shut down my Windows 7 VM earlier, it indicated that Excel was running, > even though there was no visible window. > That's why i mentioned XCEL_Application_Show which shows the hidden Excel programm > Bob S > > >> On Mar 22, 2022, at 16:06 , matthias rebbe via use-livecode >> wrote: >> >> Bob, >> are you really sure that Java is used on Windows and not VisualBasicScript? >> Here my tests showed that Excel is definitely loaded. It was hidden on the >> desktop, but it was listed in TaskManager as a running process. >> >> >> >> >> > > > ___ > use-livecode mailing list > use-livecode@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
That is to say, it IS Visual Basic doing the work. Bob S > On Mar 22, 2022, at 16:14 , Bob Sneidar wrote: > > Oh yes, that is what I read. Got my wires crossed. ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
Oh yes, that is what I read. Got my wires crossed. It's interesting that you found that Excel was running hidden. My hangups in the past may just have been that I was getting some kind of dialog but couldn't see it because the app was hidden. I say that because when I tried to shut down my Windows 7 VM earlier, it indicated that Excel was running, even though there was no visible window. Bob S > On Mar 22, 2022, at 16:06 , matthias rebbe via use-livecode > wrote: > > Bob, > are you really sure that Java is used on Windows and not VisualBasicScript? > Here my tests showed that Excel is definitely loaded. It was hidden on the > desktop, but it was listed in TaskManager as a running process. > > > > > ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
Bob, are you really sure that Java is used on Windows and not VisualBasicScript? Here my tests showed that Excel is definitely loaded. It was hidden on the desktop, but it was listed in TaskManager as a running process. > Am 22.03.2022 um 22:57 schrieb Bob Sneidar via use-livecode > : > > On the Mac, the library uses Apple Events, and for that to work it has to > launch Excel and open the spreadsheet. On Windows, it uses some kind of Java > library, so does not need to open the file or the app, which means it runs > much faster on Windows, quite the anomaly these days. :-) > > Bob S > > >> On Mar 22, 2022, at 14:40 , matthias rebbe via use-livecode >> wrote: >> >> Hm, >> i tried here and it works, but Excel is run/opened hidden. i needed to call >> XCEL_Application_Show to get Excel shown. >> >> Regards, >> Matthias >> >>> Am 22.03.2022 um 21:07 schrieb Bob Sneidar via use-livecode >>> : >>> >>> The Excel_Lib file is at the same folder level as the application. In other >>> words I can see Excel_Lib (and the other libraries) in the application >>> folder. >>> >>> Bob S >>> >>> On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode wrote: Bob, how did you include the library? As a separate stack or integrated in the .exe? Regards, Matthias > Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode > : > > Hi all. I'll try to make this as succinct as possible. > > 1. Excel_Lib works in MacOS IDE > 2. Excel_Lib works in MacOS Standalone > 3. Excel_Lib works in Windows 7 IDE > 4. Excel_Lib does NOT WORK in Windows 7 Standalone > 5. Excel_Lib works in Windows 10 IDE > 6. Excel_Lib does NOT WORK in Windows 10 standalone > > Is there something I am missing? I am not getting any alerts when it > fails, it simply doesn't access the spreadsheet files and the data they > contain. > > Bob S > > > ___ > use-livecode mailing list > use-livecode@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@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
On the Mac, the library uses Apple Events, and for that to work it has to launch Excel and open the spreadsheet. On Windows, it uses some kind of Java library, so does not need to open the file or the app, which means it runs much faster on Windows, quite the anomaly these days. :-) Bob S > On Mar 22, 2022, at 14:40 , matthias rebbe via use-livecode > wrote: > > Hm, > i tried here and it works, but Excel is run/opened hidden. i needed to call > XCEL_Application_Show to get Excel shown. > > Regards, > Matthias > >> Am 22.03.2022 um 21:07 schrieb Bob Sneidar via use-livecode >> : >> >> The Excel_Lib file is at the same folder level as the application. In other >> words I can see Excel_Lib (and the other libraries) in the application >> folder. >> >> Bob S >> >> >>> On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode >>> wrote: >>> >>> Bob, >>> >>> how did you include the library? As a separate stack or integrated in the >>> .exe? >>> >>> Regards, >>> Matthias >>> Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode : Hi all. I'll try to make this as succinct as possible. 1. Excel_Lib works in MacOS IDE 2. Excel_Lib works in MacOS Standalone 3. Excel_Lib works in Windows 7 IDE 4. Excel_Lib does NOT WORK in Windows 7 Standalone 5. Excel_Lib works in Windows 10 IDE 6. Excel_Lib does NOT WORK in Windows 10 standalone Is there something I am missing? I am not getting any alerts when it fails, it simply doesn't access the spreadsheet files and the data they contain. Bob S ___ use-livecode mailing list use-livecode@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@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
OK So I set up a debugging log to see where along the way I was going wrong. I found some anomalies, and fixed them and now it seems to be working. Bob S > On Mar 22, 2022, at 11:18 , Bob Sneidar via use-livecode > wrote: > > Hi all. I'll try to make this as succinct as possible. > > 1. Excel_Lib works in MacOS IDE > 2. Excel_Lib works in MacOS Standalone > 3. Excel_Lib works in Windows 7 IDE > 4. Excel_Lib does NOT WORK in Windows 7 Standalone > 5. Excel_Lib works in Windows 10 IDE > 6. Excel_Lib does NOT WORK in Windows 10 standalone > > Is there something I am missing? I am not getting any alerts when it fails, > it simply doesn't access the spreadsheet files and the data they contain. > > Bob S > > > ___ > use-livecode mailing list > use-livecode@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
Hm, i tried here and it works, but Excel is run/opened hidden. i needed to call XCEL_Application_Show to get Excel shown. Regards, Matthias > Am 22.03.2022 um 21:07 schrieb Bob Sneidar via use-livecode > : > > The Excel_Lib file is at the same folder level as the application. In other > words I can see Excel_Lib (and the other libraries) in the application > folder. > > Bob S > > >> On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode >> wrote: >> >> Bob, >> >> how did you include the library? As a separate stack or integrated in the >> .exe? >> >> Regards, >> Matthias >> >>> Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode >>> : >>> >>> Hi all. I'll try to make this as succinct as possible. >>> >>> 1. Excel_Lib works in MacOS IDE >>> 2. Excel_Lib works in MacOS Standalone >>> 3. Excel_Lib works in Windows 7 IDE >>> 4. Excel_Lib does NOT WORK in Windows 7 Standalone >>> 5. Excel_Lib works in Windows 10 IDE >>> 6. Excel_Lib does NOT WORK in Windows 10 standalone >>> >>> Is there something I am missing? I am not getting any alerts when it fails, >>> it simply doesn't access the spreadsheet files and the data they contain. >>> >>> Bob S >>> >>> >>> ___ >>> use-livecode mailing list >>> use-livecode@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@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
The Excel_Lib file is at the same folder level as the application. In other words I can see Excel_Lib (and the other libraries) in the application folder. Bob S > On Mar 22, 2022, at 12:20 , matthias rebbe via use-livecode > wrote: > > Bob, > > how did you include the library? As a separate stack or integrated in the > .exe? > > Regards, > Matthias > >> Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode >> : >> >> Hi all. I'll try to make this as succinct as possible. >> >> 1. Excel_Lib works in MacOS IDE >> 2. Excel_Lib works in MacOS Standalone >> 3. Excel_Lib works in Windows 7 IDE >> 4. Excel_Lib does NOT WORK in Windows 7 Standalone >> 5. Excel_Lib works in Windows 10 IDE >> 6. Excel_Lib does NOT WORK in Windows 10 standalone >> >> Is there something I am missing? I am not getting any alerts when it fails, >> it simply doesn't access the spreadsheet files and the data they contain. >> >> Bob S >> >> >> ___ >> use-livecode mailing list >> use-livecode@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@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
Re: ExcelLib in a standalone
Bob, how did you include the library? As a separate stack or integrated in the .exe? Regards, Matthias > Am 22.03.2022 um 19:18 schrieb Bob Sneidar via use-livecode > : > > Hi all. I'll try to make this as succinct as possible. > > 1. Excel_Lib works in MacOS IDE > 2. Excel_Lib works in MacOS Standalone > 3. Excel_Lib works in Windows 7 IDE > 4. Excel_Lib does NOT WORK in Windows 7 Standalone > 5. Excel_Lib works in Windows 10 IDE > 6. Excel_Lib does NOT WORK in Windows 10 standalone > > Is there something I am missing? I am not getting any alerts when it fails, > it simply doesn't access the spreadsheet files and the data they contain. > > Bob S > > > ___ > use-livecode mailing list > use-livecode@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
ExcelLib in a standalone
Hi all. I'll try to make this as succinct as possible. 1. Excel_Lib works in MacOS IDE 2. Excel_Lib works in MacOS Standalone 3. Excel_Lib works in Windows 7 IDE 4. Excel_Lib does NOT WORK in Windows 7 Standalone 5. Excel_Lib works in Windows 10 IDE 6. Excel_Lib does NOT WORK in Windows 10 standalone Is there something I am missing? I am not getting any alerts when it fails, it simply doesn't access the spreadsheet files and the data they contain. Bob S ___ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode