如何将Excel相关的BOM表列表内容导入到Excel-VBA中的Excel工作表中? [英] How to import Excel related BOM-list content into a excel sheet in Excel-VBA?

问题描述

如何实施电子表格以使其更具动态性和可回收性，以供更多用户使用?通过允许用户浏览并导入2个与Excel相关的BOM表列表文件，并将其从计算机本地驱动器导入到工作表2/3中，然后再运行上述代码以查找差异?

How to implement a spreadsheet to do something more dynamic and recyclable for more user to use? By allowing the user to browse and import 2 excel related BOM-list files from the computer local drive into sheet 2/3 before i run the above code to find the differences?

例如:像具有两个CommandButton一样可以将所有excel BOM表数据信息导入到工作表2/3中，而无需对原始文件进行任何更改?在运行任何比较测试之前，是否需要一个重置按钮来删除工作表2/3中的所有内容?

Eg: Something like having two CommandButton's which can import all the excel BOM-list data information into sheet 2/3 without making any changes to the original? Before running any comparison test and a reset button for removeing all the content in sheet 2/3?

对不起，我的英语说得不好，如果您不清楚您的解释，请解释一下.感谢您的时间/事先的帮助. :)

Sorry for my poor command of English and explanation if its not clear to you. Thanks for your time/help in advance. :)

推荐答案

我仍然不明白您要查找的内容.

i still don't understand what you are looking for.

据我能读懂您的代码，您缺少工作簿操作部分.

As far as i can read in your code, you are missing the workbook manipulation part.

您需要按照

You need to open the workbook you want to copy from with the open method as described here.

然后，您可以按照代码中的操作并按照 在本教程中 .

Then, you can manipulate the workbook and its content as you have done in your code and as described in this tutorial .

这篇关于如何将Excel相关的BOM表列表内容导入到Excel-VBA中的Excel工作表中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！