Application.ScreenUpdating = False

--
Kind regards,

Niek Otten

wrote in message oups.com...
| Hi there,
|
| I trying to insert into excel sheet values what im getting from sql. If
| you have 1 report that takes 10 min time to create maybe ok. But if you
| have more then 10.....
|
| What can use to make excel work faster?
|
| xlApp.UserControl = False
|
| What else?
|
| using win2000, vs2003 (vb) Mic. Excel 9,0 object libary
|