vb快速读取excel文件_快速关闭所有Excel文件

vb快速读取excel文件

First, I’ve got two quick announcements, and then there’s a handy Excel trick for you. Are you ready for Spreadsheet Day 2016? Quick, close all your Excel files, and bake a cake!

首先，我有两个快速公告，然后为您提供了一个方便的Excel技巧。 您准备好迎接2016年电子表格日吗？ 快速，关闭所有Excel文件，然后烤蛋糕！

2016年电子表格日 (Spreadsheet Day 2016)

You only have a few days to get ready – on Monday October 17th, it will be Spreadsheet Day. I hope you're making big plans for this important annual event! Since it's on a Monday this year, maybe you can turn it into a long weekend.

您只有几天时间可以准备就绪-10月17日，星期一， 将是Spreadsheet Day 。 希望您为此重要的年度活动制定宏伟的计划！ 由于它是在今年的星期一，也许您可​​以将其变成一个漫长的周末。

Last year, Albert Kroes had this beautiful spreadsheet cake made for his department at work, in honour of the occasion. The date on the cake, October 17, 1979, is when VisiCalc was first released, and that's why we celebrate on Oct. 17th each year.

去年，为了纪念这一机会，阿尔伯特·克罗斯(Albert Kroes)为其工作部门制作了精美的电子表格蛋糕。 蛋糕上的日期是1979年10月17日，即VisiCalc首次发布时，这就是我们每年10月17日庆祝的原因。

How will you be celebrating Spreadsheet Day 2016?

您将如何庆祝2016年电子表格日？

产品更新 (Product Update)

There was a minor update to my Data Entry Popup List kit (version 6.05). It now works correctly if you have a dependent drop down list, with only one item in the list. The only change is in the code for the frmDVList, so you can replace that in your projects, if you've run into that problem.

我的数据输入弹出列表工具包(版本6.05)进行了较小的更新。 现在，如果您有一个从属的下拉列表，并且列表中仅包含一项，则它可以正常工作。 唯一的变化是在frmDVList的代码中，因此，如果遇到此问题，则可以在项目中替换它。

To download the new version, use the link in the email that you got when you bought the product. If you can't find that email, or have used up your five downloads, let me know, and I'll send you a new link.

要下载新版本，请使用购买产品时收到的电子邮件中的链接。 如果您找不到该电子邮件，或者已经用完了五个下载，请告诉我，我会给您发送一个新链接。

关闭所有Excel文件 (Close All Your Excel Files)

In Excel 2010 and earlier, you can press Alt+F4 to close all your Excel files. In Excel 2013 and later, there is a separate window for each Excel file, and that handy trick doesn't work anymore.

在Excel 2010和更早版本中，可以按Alt + F4关闭所有Excel文件。 在Excel 2013和更高版本中，每个Excel文件都有一个单独的窗口，该方便的技巧不再起作用。

In 2013, I showed how to add the Close All button to the Quick Access Toolbar, as a way to replace that missing shortcut. It takes a minute to set up, but after that, it’s an easy way to close all your Excel file.

2013年，我展示了如何将“全部关闭”按钮添加到“快速访问工具栏”中 ，以替换丢失的快捷方式。 设置过程需要一分钟，但是之后，这是关闭所有Excel文件的简便方法。

And now there’s an even easier solution. Last week, Rostyslav made a comment on that article, describing a shortcut that he uses -- press the Shift key, and click the X at the top right of one of the Excel windows.

现在有了一个更简单的解决方案。 上周，罗斯蒂斯拉夫(Rostyslav)对该文章发表了评论，描述了他使用的快捷方式- 按Shift键，然后单击一个Excel窗口右上角的X。

I’m probably the last person to know about it, but I was very happy to learn about that shortcut to close all your Excel files!

我可能是最后一个知道它的人，但是我很高兴了解关闭所有Excel文件的快捷方式！

And as Rostyslav mentioned in his comment, there is also a "Save All" button in the Close All message. Thanks Rostyslav!

正如Rostyslav在评论中提到的，“全部关闭”消息中还有一个“全部保存”按钮。 谢谢罗斯蒂斯拉夫！

翻译自: https://contexturesblog.com/archives/2016/10/13/quickly-close-all-your-excel-files/

vb快速读取excel文件