从MS Access打开Excel One Workbook多页

问题描述

我正在尝试从Access生成一个包含多个工作表的工作簿，但到目前为止我还没有想出如何执行此操作。如何使用3个单独的Access DAO记录集并生成相同的工作簿，每个RS使用单独的工作表？我想它可以做到，但我不知道如何去做。顺便说一下，使用一个单独的工作表生成工作簿的代码工作正常。我只想在同一个工作簿中一次生成所有工作表，而不是每个工作簿只生成一个工作表。

解决方案

I am trying to generate one workbook with multiple worksheets from Access but so far I have not figured out how to do this. How does one go about taking 3 separate Access DAO recordsets and generate the same workbook with a separate worksheet per RS? I imagine it can be done, but am not sure how to go about doing it. By the way, the code for generating the Workbook with one individual worksheet is working fine. I would just like to generate all worksheets at once in the same workbook instead of just one sheet per each workbook.

解决方案

这篇关于从MS Access打开Excel One Workbook多页的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！