<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[Pandy_PB的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/Pandy_PB</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; Pandy_PB]]></copyright><item><title><![CDATA[解决先打开XLSX，后打开XLSM文件时，Workbook_Open()事件不运行的问题]]></title><link>https://blog.youkuaiyun.com/Pandy_PB/article/details/155108628</link><guid>https://blog.youkuaiyun.com/Pandy_PB/article/details/155108628</guid><author>Pandy_PB</author><pubDate>Fri, 21 Nov 2025 19:01:40 +0800</pubDate><description><![CDATA[Excel 的后台的进行若只有一个，先打开的XLSX是无宏文件（Excel 处于只读、受保护视图、禁用宏、事件被关闭 的状态），若后面直接双击打开XLSM，会导致XLSM文件中“ThisWorkbook”下的Workbook_Open() 事件无法运行.下面是XLSM的Workbook_Open()，主要是强制只读打开文件（以免误操作和保存）ThisWorkbook 下默认的open() 事件仅限单独打开XLSM宏文件时使用。若先打开的XLSX文件，后打开XLSM宏文件时此事件将会被屏蔽。]]></description><category></category></item><item><title><![CDATA[Solidworks 二次开发，eDrawings篇]]></title><link>https://blog.youkuaiyun.com/Pandy_PB/article/details/144851605</link><guid>https://blog.youkuaiyun.com/Pandy_PB/article/details/144851605</guid><author>Pandy_PB</author><pubDate>Tue, 31 Dec 2024 16:15:41 +0800</pubDate><description><![CDATA[Solidworks 二次开发，Panel控件嵌入eEdrawings]]></description><category></category></item><item><title><![CDATA[Excel表格中如何获得筛选下拉项的集合？]]></title><link>https://blog.youkuaiyun.com/Pandy_PB/article/details/121995201</link><guid>https://blog.youkuaiyun.com/Pandy_PB/article/details/121995201</guid><author>Pandy_PB</author><pubDate>Fri, 17 Dec 2021 14:16:17 +0800</pubDate><description><![CDATA[如下图：
若某列已经做了筛选，该如何获得下拉项的集合呢？

直接上代码：
Private Sub Worksheet_Activate()  '页面激活触发事件
Dim x As Integer, y As Integer, z As Integer, w As Integer, n As Integer
Dim rngCell As Range
Dim name()
Dim myCount()
Set dict = CreateObject("Scripting.Dictionary")   '此处是借用]]></description><category></category></item><item><title><![CDATA[Access数据库已设置主键，但还是提示“对于不返回任何键列信息的 SelectCommand，不支持 UpdateCommand 的动态 SQL 生成.”]]></title><link>https://blog.youkuaiyun.com/Pandy_PB/article/details/121950957</link><guid>https://blog.youkuaiyun.com/Pandy_PB/article/details/121950957</guid><author>Pandy_PB</author><pubDate>Wed, 15 Dec 2021 14:23:37 +0800</pubDate><description><![CDATA[Access数据库已设置主键，但还是提示“对于不返回任何键列信息的 SelectCommand，不支持 UpdateCommand 的动态 SQL 生成.”]]></description><category></category></item><item><title><![CDATA[VB.NET导出Outlook邮件，新建压缩文件并自动发送.]]></title><link>https://blog.youkuaiyun.com/Pandy_PB/article/details/121495907</link><guid>https://blog.youkuaiyun.com/Pandy_PB/article/details/121495907</guid><author>Pandy_PB</author><pubDate>Tue, 23 Nov 2021 16:56:51 +0800</pubDate><description><![CDATA[VB.net 链接Outlook
添加引用：
Imports Microsoft.Office.Interop.Outlook
Imports Ionic.Zip

下面直接上代码，希望能帮到大家！
1、直接压缩文件夹
        '"versionFolder" 为存档的路径
        Dim versionFolder As String = "" &amp; SubDir.FullName &amp; "\07-Hot runner System drawing 3D"
        '"]]></description><category></category></item></channel></rss>