Minimise Window

[sanjna000]

Hi there,

My VBA program is uses to copy data using 2 different workbooks. At the moment i am using a form to activate this code, and once i click OK button to start copying it opens up relevant work books and copies data. But the problem is it takes lot of time since i ve got lots of data in my spreadsheets. So what i really want to do is i need to minimise the excel work book windows while its copying data. How can i do that?

Thank you for u r help!
Sanjna...

 

[DPlank]

Minimising the workbooks won't speed up the process, but if you just want to avoid showing that you have opened other workbooks you can insert this code before the open events:

Application.ScreenUpdating = False

HTH
David

"Probably the only Test Analyst on Tek-Tips"

 

[sanjna000]

Thanks David. It really helped me a lot!