If you're just opening it briefly to extract information:

Application.Screenupdating=false
'open, extract, close
Application.Screenupdating=true

Tim

On Dec 2, 6:42*am, John wrote:
Ok, thanks... I got all that. Now another problem.

Dim FileName as string
Dim Wb as Workbook
I get the name of the workbook file in the string then open it with
Set Wb = Applicatin.Workbooks.Open(Filename, , , , "password")

How do I get the workbook to say hidden? I want to get info out of it
but I don't want it to be flashing all over the screen when I open and
access it.

I tried Wb.hide but it said isn't appropriate.

Thanks
JOhn