使用脚本字典的Excel VBA /高级过滤器 [英] Excel VBA / Advanced Filter Using a Scripting Dictionary

问题描述

您好 - 我正在尝试找到一种在VBA宏中执行高级过滤器的方法，该方法不需要我创建临时工作表来放置结果，处理它们，然后删除临时表。我需要在其中执行此操作的电子表格可能很大，并且每月将执行多次以处理客户的清单。有人建议我可以使用脚本字典作为高级过滤器的对象，其中存储唯一条目，然后可以使用
来处理月度数据。但是，我只是表面上熟悉脚本字典，现在不知道在高级过滤器命令中使用VBA宏中的一个。

Hello - I'm trying to find a way to execute an Advanced Filter in a VBA macro that does not require me to create a temporary worksheet to place results, process them, and then delete the temporary sheet. The spreadsheet in which I need to do this can be large, and will be executed many times each month to process a laundry list of customers. It was suggested to me that I might be able to use a Scripting Dictionary as the object of an Advanced Filter where unique entries would be stored and could then be used to process monthly data. However, I am only superficially familiar with Scripting Dictionaries and don't know now to use one in a VBA macro in an advanced filter command.

有关如何执行此操作的任何建议，请使用非常感谢脚本字典或其他一些方法。

Any suggestions on how to do this, using a scripting dictionary or some other method, would be appreciated.

谢谢，

Tim

推荐答案

你好，

我注意到你正在寻找VBA宏来进行高级过滤。为了更好地解决问题，我将把线程移到Excel for Developers论坛以获得更多帮助。那里的贡献者熟悉VBA代码，他们可以根据您的要求提供更多建议
。感谢您的理解。

I notice that your are looking for VBA macro to do the Advanced Filter. To better resolve the issue, I would move the thread to Excel for Developers forum for more help. The contributors there is familiar with VBA codes and they can provide more suggestions for your requirement. Thanks for your understanding.

这篇关于使用脚本字典的Excel VBA /高级过滤器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！