Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OleBound control show Excel chart slow
Message
From
18/05/2023 03:57:13
 
 
To
18/05/2023 03:02:07
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
01686592
Message ID:
01686593
Views:
41
>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)
>append blank
>append general bla from (lcF)
>thisform.oleboundcontrol1.ControlSource="bla.bla"
>thisform.oleboundcontrol1.refresh()
>This code executes quickly and in excel prior 2016 show in 1 second.
>But in new excel it takes 10+ seconds.
>Now are all PCs in my company new and modern :(
>Is there any vfp solution ?

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.
You might try making sure you have only one instance of Excel running at any given time, see if that makes any difference.
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
Next
Reply
Map
View

Click here to load this message in the networking platform