访问 - > Excel Automation慢 [英] Access -> Excel Automation Slow

问题描述

大家好，

我使用Access 2000生成超过40个Excel图表和数据透视表

使用早期绑定到Excel 9.0对象库。我发现如果我在处理图表时显示Excel对象，整个过程

大约需要2分钟。但是，如果我隐藏Excel对象，则相同的

过程大约需要27分钟才能完成。我玩了

屏幕更新，这对时间没有什么不同。有没有人

有什么建议我可以用Excel

对象隐藏来减少处理时间吗？


任何帮助表示感谢，

Mark Day。

Hi All,
I am using Access 2000 to generate over 40 Excel charts and pivot tables
using early binding to the Excel 9.0 object library. I am finding that if I
show the Excel object while processing the charts, the whole process
completes in around 2 minutes. However if I hide the Excel object the same
process takes around 27 minutes to complete. I have played around with
screen updating and this makes no real difference to the time. Does anybody
have any suggestions how I could cut down the processing time with the Excel
object hidden?

Any help appreciated,
Mark Day.

推荐答案

这看起来很奇怪。当你看到它时，你会认为它会慢*。


在整个自动化代码中加入一些定时器，看看减速是否为
任何特别的地方。


dim x as single

x = -timer

（在这里做一些事情）

x = x + timer

debug.print" take" ;; X; "秒'


HTH，

TC

" Mark Day" <毫安****** @ solortec.co.uk>在消息中写道

新闻：bm ********** @ hercules.btinternet.com ...

This seems strange. You''d think it would be *slower* when made visible.

Put some timers throughout the automation code, to see if the slowdown is
any in particular place.

dim x as single
x = -timer
(do some stuff here)
x = x + timer
debug.print "took "; x; " seconds"

HTH,
TC
"Mark Day" <ma******@solortec.co.uk> wrote in message
news:bm**********@hercules.btinternet.com...

大家好，
我是使用Access 2000生成超过40个Excel图表和数据透视表
使用早期绑定到Excel 9.0对象库。我发现如果
我在处理图表时显示Excel对象，整个过程将在大约2分钟内完成。但是，如果我隐藏Excel对象，则相同的过程大约需要27分钟才能完成。我玩过
屏幕更新，这对时间没有什么不同。
是否有人建议我如何通过隐藏
Excel对象来减少处理时间？

任何帮助表示赞赏，
Mark Day。

Hi All,
I am using Access 2000 to generate over 40 Excel charts and pivot tables
using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing the charts, the whole process
completes in around 2 minutes. However if I hide the Excel object the same
process takes around 27 minutes to complete. I have played around with
screen updating and this makes no real difference to the time. Does anybody have any suggestions how I could cut down the processing time with the Excel object hidden?

Any help appreciated,
Mark Day.

我已经有定时器了，好像没有任何地方

导致此减速的代码。如果我显示Excel对象然后通过代码最小化

窗口，这与将Excel对象隐藏为

的效果相同，就像处理时间一样。但是，如果Excel对象具有

焦点，那么处理时间会显着减少。

任何其他想法??


TIA

Mark Day。


" TC" < a@b.c.d>在消息新闻中写道：1065760695.602269@teuthos ...

Hi,
I already have timers in place and there does not appear to be any place in
code that causes this slowdown. If I show the Excel object and then minimise
the window via code, this has the same effect as hiding the Excel object as
far as processing time is concerned. However if the Excel object has the
focus, then the processing time dramaticaly reduces.
Any other ideas??

TIA
Mark Day.

"TC" <a@b.c.d> wrote in message news:1065760695.602269@teuthos...

这看起来很奇怪。当你看到它时，你会认为它会变慢*。

在整个自动化代码中加入一些定时器，看看是否在特定的地方放慢速度。

dim x as single
x = -timer
（在这里做一些事情）
x = x + timer
debug.print" take" ;; X; "秒

HTH，
TC

" Mark Day" <毫安****** @ solortec.co.uk>在消息中写道
新闻：bm ********** @ hercules.btinternet.com ...

This seems strange. You''d think it would be *slower* when made visible.

Put some timers throughout the automation code, to see if the slowdown is
any in particular place.

dim x as single
x = -timer
(do some stuff here)
x = x + timer
debug.print "took "; x; " seconds"

HTH,
TC
"Mark Day" <ma******@solortec.co.uk> wrote in message
news:bm**********@hercules.btinternet.com...

大家好，
我正在使用Access 2000来使用早期绑定到Excel 9.0对象库生成超过40个Excel图表和数据透视表。我发现
如果

Hi All,
I am using Access 2000 to generate over 40 Excel charts and pivot tables
using early binding to the Excel 9.0 object library. I am finding that if

我

在处理图表时显示Excel对象，整个过程大约在2分钟内完成。但是，如果我隐藏Excel对象

show the Excel object while processing the charts, the whole process
completes in around 2 minutes. However if I hide the Excel object the

相同的过程大约需要27分钟才能完成。我玩过
屏幕更新，这对时间没有什么不同。

same process takes around 27 minutes to complete. I have played around with
screen updating and this makes no real difference to the time. Does

任何人

有任何建议我如何使用

来减少处理时间
Excel

Excel

对象隐藏？

任何帮助表示赞赏，
Mark Day。

object hidden?

Any help appreciated,
Mark Day.

听起来像操作系统问题如何处理后台任务。


-


Alphonse Giambrone

电子邮件：a-giam at customdatasolutions dot us

" Mark Day" <毫安****** @ solortec.co.uk>在消息中写道

新闻：bm ********** @ hercules.btinternet.com ...

Sounds like an OS issue with how it handles background tasks.

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us
"Mark Day" <ma******@solortec.co.uk> wrote in message
news:bm**********@hercules.btinternet.com...

大家好，
我是使用Access 2000生成超过40个Excel图表和数据透视表
使用早期绑定到Excel 9.0对象库。我发现如果
我在处理图表时显示Excel对象，整个过程将在大约2分钟内完成。但是，如果我隐藏Excel对象，则相同的过程大约需要27分钟才能完成。我玩过
屏幕更新，这对时间没有什么不同。
是否有人建议我如何通过隐藏
Excel对象来减少处理时间？

任何帮助表示赞赏，
Mark Day。

Hi All,
I am using Access 2000 to generate over 40 Excel charts and pivot tables
using early binding to the Excel 9.0 object library. I am finding that if I show the Excel object while processing the charts, the whole process
completes in around 2 minutes. However if I hide the Excel object the same
process takes around 27 minutes to complete. I have played around with
screen updating and this makes no real difference to the time. Does anybody have any suggestions how I could cut down the processing time with the Excel object hidden?

Any help appreciated,
Mark Day.

这篇关于访问 - &gt; Excel Automation慢的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！