View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul H[_2_] Paul H[_2_] is offline
external usenet poster
 
Posts: 55
Default Slows after about 1,000 records?

I am creating an XLS file from a CSV file using COBOL Net Express, adding
one record at a time. I use various INVOKE statements. After about 1,000
records the speed drops to about 1/4 of the prior rate per minute. I doubt
that the speed of reading the input file changes. Is this because of an
Excel overflow buffer issue? How can I fix this? TIA, Paul