<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[lchgwp100的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/lchgwp100</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; lchgwp100]]></copyright><item><title><![CDATA[VBA把JSON字符串转为数组，在VBA中解析JSON对象数组为VBA数组对象]]></title><link>https://blog.youkuaiyun.com/lchgwp100/article/details/124028357</link><guid>https://blog.youkuaiyun.com/lchgwp100/article/details/124028357</guid><author>lchgwp100</author><pubDate>Thu, 07 Apr 2022 22:37:42 +0800</pubDate><description><![CDATA['VBA把JSON字符串转为数组，在VBA中解析JSON对象数组为VBA数组对象
'Andy 2022.04.07
功能：把VBA获取的网页JSON对象数组，转换成本地VBA数组，供本地程序使用
特色：实现二维表格数据直接转换，在VBA中使用JS代码轻松实现]]></description><category></category></item><item><title><![CDATA[EXCEL之VBA将记录集赋值给数组及数组常用操作]]></title><link>https://blog.youkuaiyun.com/lchgwp100/article/details/101764724</link><guid>https://blog.youkuaiyun.com/lchgwp100/article/details/101764724</guid><author>lchgwp100</author><pubDate>Mon, 30 Sep 2019 12:47:03 +0800</pubDate><description><![CDATA[myarray=rs.GetRows'将记录集结果赋值给数组示例语句

重置数组大小
ReDim myarray(UBound(myarray) + 1)'重置数组大小不保留原来数据
ReDim Preserve myarray(UBound(myarray) + 1)'重置数组大小且保留原来数据

将数组写入表格
[a1:a?] = Application.WorksheetFunction.T...]]></description><category></category></item><item><title><![CDATA[在EXCEL的VBA中使用DAO方式及ADO方式连接ACCESS数据库示例代码]]></title><link>https://blog.youkuaiyun.com/lchgwp100/article/details/101764614</link><guid>https://blog.youkuaiyun.com/lchgwp100/article/details/101764614</guid><author>lchgwp100</author><pubDate>Mon, 30 Sep 2019 12:44:44 +0800</pubDate><description><![CDATA[在EXCEL的VBA中使用DAO方式及ADO方式连接ACCESS数据库示例代码
'*******************************************************DAO(DAO 3.6 Object)方式*******************************************

Public Function DAO_SHILIE() As Intege...]]></description><category></category></item><item><title><![CDATA[2008 Server R2 IIS7.5环境 thinkPHP框架下 隐藏index.php (URL重定向设置）]]></title><link>https://blog.youkuaiyun.com/lchgwp100/article/details/85261281</link><guid>https://blog.youkuaiyun.com/lchgwp100/article/details/85261281</guid><author>lchgwp100</author><pubDate>Wed, 26 Dec 2018 14:15:35 +0800</pubDate><description><![CDATA[2008 Server R2 IIS7.5环境 thinkPHP框架下 隐藏index.php
直接进入步骤：
1.配置前必须安装微软的URL Rewrite模块 网址是:
https://www.iis.net/downloads/microsoft/url-rewrite#additionalDownloads
2.在网站根目录修改或增加 web.config 文件（&amp;lt;rewrite&amp;g...]]></description><category></category></item></channel></rss>