View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PJ[_4_] PJ[_4_] is offline
external usenet poster
 
Posts: 3
Default Can I stop Excel program flashing on screen during run

I have some code that processes files in a directory and
extracts one piece of data. During the process a the
following is executed:
Workbooks.OpenText Filename:= _
strDirName & strItem, Origin:=xlMSDOS, StartRow:=2,
DataType:=xlFixedWidth, FieldInfo:= _
Array(Array(0, 1), Array(146, 1), Array(156, 1)),
TrailingMinusNumbers:=True

While this is running - it flashes on the screen.

Is there any way of stopping this?