Is it possible to create an multi threaded application,
是否可以创建多线程应用程序,
The lists all the pivot tables in an excel document,
列出Excel文档中的所有数据透视表,
And fires a new thread to refresh each pivot table.
并触发一个新线程来刷新每个数据透视表。
Currently a applicatoin.refreshall takes 3hrs.
目前,applicatoin.refreshall需要3个小时。
I also do not think that vba code can be mulithreaded.
我也不认为vba代码可以是多线程的。
Any ideas welcome
欢迎任何想法
1 个解决方案
#1
I'm not sure that making this process multithreaded would necessarily help. 3 hours is a pretty long time for anything - I suspect you have other problems with this excel document. How big is the file?
我不确定这个过程是多线程的,这无疑会有所帮助。任何事情都需要3个小时 - 我怀疑这个excel文档还有其他问题。文件有多大?
#1
I'm not sure that making this process multithreaded would necessarily help. 3 hours is a pretty long time for anything - I suspect you have other problems with this excel document. How big is the file?
我不确定这个过程是多线程的,这无疑会有所帮助。任何事情都需要3个小时 - 我怀疑这个excel文档还有其他问题。文件有多大?