Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OleBound control show Excel chart slow
Message
From
18/05/2023 14:39:37
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01686592
Message ID:
01686598
Views:
57
>>>Hello,
>>>I show Excel chart on VFP forms with OleBoundControls. It works fine, until come Excel 2016 and higher.
>>>lcF= some excel file
>>>create cursor bla (bla g)
>>...
>>This is not a solution. I've noticed that sometimes when using Excel, first workbook opens immediately. Opening second or subsequent ones can take a long time.
>
> It's a security feature - delay some seconds "unlocking" sheet.

Do you have a reference for that?

After a little Googling I found some articles which imply it's an issue with DDE:
https://learn.microsoft.com/en-us/answers/questions/206248/excel-slow-to-open-second-(or-subsequent)-file
https://answers.microsoft.com/en-us/msoffice/forum/all/excel-opens-2nd-subsequent-file-from-explorer/907165a8-44a4-4212-a871-6525b7553eaa
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Previous
Reply
Map
View

Click here to load this message in the networking platform