VB6编写动态数据源并在EXCEL 2007/2010工作表中刷新结果 [英] VB6 write dynamic Data source and refresh the result within a EXCEL 2007/2010 worksheet

问题描述

我需要从SQL数据库输出3 x 86400条记录并将其写入工作表（我尝试逐个写入记录但是它需要难以置信的长时间来处理。所以我创建了3个数据源并使用VBA宏生成以下代码和
然后我将这些代码嵌入到我的VB6应用程序中。它与常量日期工作正常但我只是不能使用变量。

I needs to output 3 x 86400 records from a SQL database and write it to a worksheet (I tried write the record one-by-one but it takes unbelievable long time to process. So I created 3 data sources and using the VBA Macro to generate the below code and then I embed those code to my VB6 application. It is working fine with the constant date but I just cannot use variable on it.

你能帮我解决一下这个问题吗？ 

Could you please help me on how to do this ?? 

提前致谢!!

推荐答案

您好kkcci88888，

Hi kkcci88888,

欢迎来到MSDN论坛。

Welcome to the MSDN forum.

这个队列是关于vb.net的。我担心你关于VB6的话题不适合这里。我会把这个帖子移到主题论坛。你​​可以通过这个链接找到正确的论坛：

http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b 。

This queue is about vb.net. I’m afraid that your topic about VB6 is unsuitable here. I will move this thread to off topic forum. You can find the correct forum with the help of this link: http://social.msdn.microsoft.com/Forums/en-US/vbgeneral/thread/6a0719fe-14af-47f7-9f51-a8ea2b9c8d6b.

很抱歉给您带来不便，祝您有个愉快的一天。

Sorry for any inconvenience and have a nice day.

这篇关于VB6编写动态数据源并在EXCEL 2007/2010工作表中刷新结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！