ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automation from VB - slower than from Excel (https://www.excelbanter.com/excel-programming/295526-automation-vbulletin-slower-than-excel.html)

Rhys

Automation from VB - slower than from Excel
 
Hello all

I am automating an excel object from VB6 that embedds the excel object onto an MDI Form, making the form the parent
Whenever I programmatically open a worksheet from a DFS server path the file takes longer to open than if I had opened the file through Excel - quite a lot longer!
Is there a specific reason for this? Can this process be speeded up?

TIA

Rhys.


All times are GMT +1. The time now is 12:20 PM.

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