合并工作表 [英] Combine worksheets

问题描述

早上好每个人。

我想将6个工作簿合并在一起，它们都具有相同的格式，所有标题都相同，并且都位于名为merged的同一个文件夹中。我有这个代码（下面），但我一直在第3行得到用户定义的错误，我不明白为什么...有些请帮我合并这些文件我会很感激它太多了


谢谢

Good Morning Everyone.
i would like to merge 6 workbook together they are all the same format all with the same headers and are all in the same folder called merged. I have this code ( below) but i keep getting User defined error on line 3and i dont understand why... Some please help me merge these files together i would appreciate it sooo much

Thanks

展开 | 选择 | Wrap | 行号

推荐答案

当昏暗类型不自动显示或出现错误时，表示它在VBA中无法识别。

您必须插入参考：Microsoft DAO 3.6对象库。与班级记录集

When the dim type not shows automatically or when it gives an error, it means that it is not recognized in VBA.
You have to inset the Reference: "Microsoft DAO 3.6 object library" with the class "recordset"

Hello Guido，感谢您的回复。我有最糟糕的时间来解决这个问题我已经尝试了我认为过去一周的几乎所有内容我都认真考虑转换为Access，因为我无法合并工作表并保持原始来源，如果进行了更改原始然后它反映在主副本上。我希望能够将所有工作簿组合在同一个文件夹中。我认为我的桌子已准备就绪。我附加了一个工作簿，这是可以做的一些事情

Hello Guido, Thanks for the respone. I am having the worst time figuring this out I have tried i think almost everything for the past week I am serious thinking of converting to Access for this because i cannot combine the worksheet and keep the source from the orginal, If a change is made on the orginal then it refelts on the Master copy. I would like to be able to Combine all workbooks in the same folder. I think that my table is all ready in array. I have attached a the workbook is this some thing that can be done

附加文件

< a href =https://bytes.com/attachments/attachment/5660d1321370075/bytes.com-combining-2-.zip> Bytes.com组合（2）.zip （55.6 KB，12 views）

Attached Files

Bytes.com Combining (2).zip (55.6 KB, 12 views)

这将复制文件夹中所有工作簿的工作表：

This will copy the sheets from all workbooks in the folder:

展开 | 选择 | Wrap | 行号

这篇关于合并工作表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！