运行宏时使用Excel [英] Use Excel when a macro is running

问题描述

我不知道这是否可以完成，但是如果用户在后端运行宏时，用户可以使用excel电子表格，那将是非常好的。有什么办法可以做到吗？谢谢。

I am not sure if this can be done, but it would be great if the user can use the excel spreadsheet while the macro is running at the backend. Is there any way this can be done? Thanks.

编辑：用户重复（> 10 ^ 5次）通过宏生成n个项目（n〜100）的随机排列。这可能需要10-15分钟（或更多）才能完成。所以，如果用户可以打开excel工作簿来执行其他任务，而在宏运行的时候，这将是很好的。 （它通常是与宏运行的工作簿不同的工作簿）。请让我知道如果这可以完成，如果是的话，它可能对正在运行的宏的性能影响。谢谢。

The user is repeatedly (>10^5 times) generating Random permutations on n items (n ~ 100) through a macro. This might take around 10-15 mins (or more) to get done. So, if the user can open the excel workbook to do other tasks, while the macro is running , it would be nice. (It would typically be a different workbook from the one in which macro is running). Please let me know if this can be done and if yes, any performance effects that it might have on the macro which is running. Thanks.

推荐答案

用户可以在宏运行时打开Excel应用程序的第二个实例，并在其他工作簿上正常工作。同样的工作簿也可以打开，但只能读取。

The user can open a second instance of the Excel application while the macro is running and work as normal on other workbooks. The same workbook can also be opened but as read only.

这篇关于运行宏时使用Excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！