Opening Workbooks
 

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.

Opening Workbooks
 

Application.ScreenUpdating=false
will stop this anoying flickering
--
Best regards
Luc Nuyts
www.scriptingIT.be


" wrote:

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.

Opening Workbooks
 

Many thanks Luc.

Opening Workbooks
 

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 he
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

" wrote:

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.