Open Excel spreadsheet in invisible mode

[neemi]

I am opening a spreadsheet using the code

Set wkbInput = Workbooks.Open(gsWorkFolder & "\" & fil.Name, UpdateLinks:=False, ReadOnly:=True)

This is opened from another spreadsheet. therefore cannot really have the application hidden. Need to specify which file to hide.

Is there anyway I can specify that this is to be opened in invisble mode as I am just opening it to check a value and then closing it straight after. There are quite a lot of spreadsheets that I loop through and as you can imagine they just flash open and then close.

The user does not need to see them open so thought it would be a good idea to keep it hidden/

help appreciated.
Hope you understand the question.

 

[xlbo]

application.screenupdating = false
your code
application.screenupdating = true

no need to "hide" the file - just stop the screen jumping around

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[neemi]

I thought of doing that and it works fine but the code is b=very complicated and have a lot of msgboxes etc which work fine. But when the user clicks on an option the msgbox remains on screen. And without toggling between the screenupdating at every msgbox it will remain on screen. as well as the main spreadsheet which is updated in sections it would be usefull to see this being updated as it is filled in.

Using the screenupdating I would probably have close to 50 screen updates between True and false. :-/

 

[N1GHTEYES]

If all you want is some data from the other workbooks, can you not simply get the data without opening them? See thread707-953232.

Tony