View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Ole M Halck Ole M Halck is offline
external usenet poster
 
Posts: 2
Default VBA execution stops at ActiveSheet.Copy -- but only sometimes!

On Tue, 17 Aug 2004 10:50:05 -0400, "Jim Rech"
wrote:

Just a shot in the dark but I'd suggest making sure no other code is running
when the text file is opened. Do that by making sure
Application.EnableEvents is set to False and that calculation mode is set to
manual (so no UDFs run). Add a step to enable events when your code is
finished.


Thanks for your suggestion, Jim -- I'll try that.

--
OleM