使用VBA创建数据透视表（Access 2007） [英] Create Pivot Table using VBA (Access 2007)

问题描述

我已经制作了一个Excel（2007）工作表，我想用它创建一个数据透视表。这将完全从Access 2007数据库上运行的模块完成。


请大家为此提供一些简单的代码吗？


非常感谢您收到的任何帮助。

I have produced an Excel (2007) worksheet, with which I want to create a Pivot Table. This would all be done from a module run on an Access 2007 database.

Please can anyone supply some simple code for this?

Many thanks for any help received.

推荐答案

我不敢。


我们在这里帮助人们发展自己的工作，而不是为他们做工作。这有灵活性，但在这种情况下，它可能很容易成为家庭作业或项目问题，我们会非常犹豫提供任何东西。


请参阅发布指南，了解如何以我们可以帮助的方式重做此内容。

I''m afraid not.

We are here to assist people to develop their own work, not to do the work for them. There''s flexibility to this, but in a case such as this, where it could easily be a homework or project question, we would be very hesitant to provide anything.

Please see the Posting Guidelines for how you could redo this in such a way that we can help.

这不是作业，也不是项目问题。


我在网上遇到过各种代码并查看了输出来自在escel（2007）中创建数据透视表时的宏录制。


但是，当将其传输到vba模块时，我不断收到错误。我徒劳地试图看看是否能快速简单地解决这个问题，我提出了这个帖子。


我见过更简单（我知道，在我看来）问题解决了在这个论坛上，所以在这里问问似乎是正确的。

This is not homework, nor a project question.

I have come across various bits of code on the net and looked at output from a macro recording when creating a pivot table in escel (2007).

However, when transferring this to a vba module, I keep getting errors. In a vain attempt to see if there was a quick and simple resolution to this problem, I raised this post.

I have seen far simpler (I know, in my opinion) problems resolved in this forum, so it seemed right to ask here.

我当然不是说你不能寻求帮助。也不是问题太复杂。


请重新阅读帖子，特别参考链接的帮助部分，该部分说明应该如何提问。发布你所拥有的内容，并解释什么是失败的地方，是可以接受的。没有什么可以阻止我或其他任何人在那个阶段提供更好的代码，如果这看起来合适的话。


我们都不想让人难以提问（为什么我们要在这里？），但链接确实解释了我们在提问时的期望，以及为什么如果你有兴趣深入了解它。

I''m certainly not saying you can''t ask for help. Nor that the problem is too complex.

Please reread the post, with specific reference to the linked Help section that tells how questions should be asked. Posting what you have, with an explanation of what''s failing where, would be acceptable. There is nothing to stop me, or anyone else, providing better code at that stage if that seems appropriate.

None of us is looking to make it hard to ask questions (why would we be here for that?), but the link does explain what we expect in the way of asking questions, and alo why if you''re interested to look that deeply.

这篇关于使用VBA创建数据透视表（Access 2007）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！