| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 | |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Function that makes excel work faster
Im using CopyFromRecordSet...
Application.ScreenUpdating = False --not helping.... |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking makes filter macro not work | Excel Discussion (Misc queries) | |||
| Make Excel work faster | Excel Programming | |||
| How to get Excel to work faster | Excel Worksheet Functions | |||
| Make Excel Work faster | New Users to Excel | |||
| Can faster CPU+larger/faster RAM significantly speed up recalulati | Excel Discussion (Misc queries) | |||
Hybrid Mode
