Opening Workbooks

[skulkrinbait]

Hello, not sure if this is possible but can anyone help please?

I've got a macro which, amongst other things, opens various files to
retrieve data for processing. It opens these files in turn and gets
the data it needs etc before closing them again, using the following
commands:

Workbooks.OpenText
' Do some processing
ActiveWorkbook.Close

It works OK but the screen flickers madly for a few seconds during
this time and I'm worried I might get epilepsy - not really, but it
does look really bad.

Is it possible to process these files another way without them being
displayed to avoid the flickering? I don't need them to be displayed,
they are only there for a split second anyway.

Thanks.

 

[Luc]

Application.ScreenUpdating=false
will stop this anoying flickering

 

[skulkrinbait]

Many thanks Luc.

 

[Philip]

As well as Luc's suggestion, you could additionally look on Ron de Bruin's
excellent website - he shows how to use ADO to retrieve data from closed
workbooks without opening them (essentially trating the worksheets like
database tables)

have a look here:
http://www.rondebruin.nl/ado.htm

Also, John Walkenbach has a page on this too:
http://www.j-walk.com/ss/excel/tips/tip82.htm

Both well worth 10 minutes of your time!

HTH

Philip