Excel Links Performance vs API

Solution Partner Phenom Solution Partner Phenom
Solution Partner Phenom

Can anyone comment on performance of Excel links created via Copy-Paste Link verses using the Solid Edge API?

I have a customer that has created over 1000 links and is suffering performance problems.

We are not sure exactly where the problem is. 40 minute compute time.

I wrote a script to convert all the links to VBA code in his Excel and learned that VBA has a limit of the size of any one procedure. So that was fail.

Considering other coding options but only if will help.

Anyone have input before I invest time in this?

Thanks!

Jason T.

LMGi
www.TLMGi.com
1 REPLY

Re: Excel Links Performance vs API

Phenom
Phenom

Hi Jason:

  

I can relate a closely similar case but it was quite some time back.

We had a part with about 165 links from Excel and Solid Edge would repeatedly crash.

So we quickly gave up and also skipped Excel VBA.

Wrote a program using VB 6 with just variable update calls and it worked fine even as we later scaled it up to 300+ variables including those for various other parts in the assembly.

  

But as I said it was a very old version of SE before the ST era.

 

~Tushar