AnsweredAssumed Answered

VRF = DDE - problem

Question asked by VRFuser on May 7, 1998
> I am working on a project that requires me to write an extremely large
> 2D Array from VEE to EXCEL97. "Large" being 20000 (twenty-thousand).
> The problem I am experiencing is that not everything is written to
> EXCEL, it might come up to about 16000 or less. I have tried different
> formats, timeouts and so on.
> Does anybody know an answer to this problem? If yes, please let me
> know.

I've never had much luck with DDE's.  There always seems to be a
question of which program is doing what at what time.

I have been simply writing data to a text file, calling Excel with the
/run flag and a small macro to load the file.  It works flawlessly...

I've used this same approach with other programs too.

    _
   /      Greg.Noseworthy@comdev.ca
  / __    ComDev
/ / _    -----------------------------
(_/_/___)  Space Group

Outcomes