View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
MikeT MikeT is offline
external usenet poster
 
Posts: 32
Default Help with Slow Print Routine

Ok, I figured out my problem, now the code runs about 1000 times faster,
believe it or not. I changed the code to use a textstream object, and still
had performance issues. Then I changed the the 'format' property of the
textstream from ASCII to Unicode (I have Unicode characters in the sheet).
Performance went from about 20 minutes to copy a sheet to less than 1 second!