Sharepoint“导出到电子表格”问题
我刚刚开始使用 VBA 进行编程，尽管我进行了研究，但仍有一个问题要向社区提出……
是否可以使用 VBA 宏执行共享点操作“导出到电子表格”？
如果您想知道我要做什么，我想导出到 Excel 并创建一些数据透视表。
朝着正确的方向推动将非常有帮助......我希望我有一些代码可以发布，但我仍处于规划/研究阶段。
I have just begun programming in VBA and despite my researching efforts have a quick question for the community...
Is it possible to perform the sharepoint action "Export to Spreadsheet" using a VBA macro?
I want to export to excel and create a few pivot tables if you are wondering where I am going with this.
A push in the right direction would be extremely helpful... I wish I had some code to post but I am still in the planning/researching stage.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我首先要感谢 @Tim Williams 引导我访问 support.microsoft.com/kb/930006 链接，因为我相信我已经找到了我的问题的解决方案。 （如果我有足够的声誉，您的评论将会被投票！）
我能够从“导出到电子表格”命令生成一个 .iqy 文件，我已成功地将其传输到 VBA Web 查询中。或者，我可以简单地保存 .iqy 文件并使用 VBA 代码打开它。两者都已成功填充我的电子表格，因此我现在可以完成我想要做的报告。
I would first like to thank @Tim Williams for directing me towards the support.microsoft.com/kb/930006 link as I believe I have found a solution to my question. (If I had enough reputation your comments would be upvoted!)
I was able to generate an .iqy file from the "Export to Spreadsheet" command which I have successfully transferred into a VBA web query. Alternatively, I was able to simply save the .iqy file and open it with the VBA code. Both have successfully populated my spreadsheet so I can now do the reporting I was looking to do.