swiwthcing between sheets and viewing pages?
 

I have a macro thata runs on sheet1 of program1.xls. It accesses filenames
on sheet2 of program1.xls and then opens the file name (ie program2.xls) to
obtain data and put that data on sheet1 of program1.xls.

The program is currently functional.

The program however opens all of these different sheets and files and shows
me the spreadsheet on each of them as it accesses the data. I would prefer
that i only see sheet1 of Program1.xls while this data transfer is taking
place. Is there a way to open sheet2 of program1.xls and program2.xls and do
the functions that i need to have done while keeping it in the backgroud so i
dont have to see this happening?


--
dr chuck

swiwthcing between sheets and viewing pages?
 

Application.ScreenUpdating = False

' process workbooks

Application.ScreenUpdating = True

--
Regards,
Tom Ogilvy

"dr chuck" wrote in message
...
I have a macro thata runs on sheet1 of program1.xls. It accesses filenames
on sheet2 of program1.xls and then opens the file name (ie program2.xls)
to
obtain data and put that data on sheet1 of program1.xls.

The program is currently functional.

The program however opens all of these different sheets and files and
shows
me the spreadsheet on each of them as it accesses the data. I would
prefer
that i only see sheet1 of Program1.xls while this data transfer is taking
place. Is there a way to open sheet2 of program1.xls and program2.xls and
do
the functions that i need to have done while keeping it in the backgroud
so i
dont have to see this happening?


--
dr chuck