Function that makes excel work faster
 

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

Function that makes excel work faster
 

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
|

Function that makes excel work faster
 

Maybe also

Application.Calculation = xlCalculationManual

remember to reset at the end.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Niek Otten" wrote in message
...
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
|

Function that makes excel work faster
 

IF you can determine the insertion cell for each SQL,
ANDIF the recordset has the desired order for insertion in Excel.

you might use CopyFromRecordSet : see the help file.

" wrote:

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

Function that makes excel work faster
 

Im using CopyFromRecordSet...

Application.ScreenUpdating = False --not helping....

Function that makes excel work faster
 

Is it Excel that is slow, or is it your query? I am guessing it is probably
the query - Excel is probably just waiting for the results. I think you
probably need to see if you can optimize your query instead of trying to
speed up Excel.
--
- K Dales


" wrote:

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