swiwthcing between sheets and viewing pages?

D

dr chuck

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?
 
T

Tom Ogilvy

Application.ScreenUpdating = False

' process workbooks

Application.ScreenUpdating = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top