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.
|