Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Opening new workbooks | Excel Discussion (Misc queries) | |||
Opening Workbooks | Excel Programming | |||
Opening workbooks | Excel Discussion (Misc queries) | |||
multiple workbooks opening | Excel Programming | |||
Questions upon opening workbooks | Excel Programming |