Slow operation

[Bob Jase]

Ok,
There are two complications.
From VB I open through COM a server program of my own design, that server opens through COM Excel. Then when its done with Excel, VB gives the focus back to my private server.
Now, when my server opens Excel, it asks me "Do you want to update Links" bc its dealing with a copy of a default file i created with links, and i have to answer no. (if theres a way to have it not ask me that would be nice too, but thats not my current problem). My current problem is that when my server runs Excel, it runs REALLY SLOW., but if i make excel visible AND give it focus, it runs nice and fast.
Does anyone know of any reason this should happen or of any possible remedy?

Thanks in advance,
Bob.

[delports]

to disable the links you have to specify the following when you open the file:
MyExcel.Workbooks.Open Filename:="C:yourfile.xls" UpdateLinks:=false



my guess for excel being slow is that it is either trying to update the links in the workbook or the location of your workbook is on a different server. check the speed when you disable the links.
hope it helps