View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rhys Rhys is offline
external usenet poster
 
Posts: 1
Default 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.