ExcelVBA程序开发自学宝典(第3版)案例文件

[{"title":"（329个子文件19.93MB）ExcelVBA程序开发自学宝典(第3版)案例文件","children":[{"title":"10-3使用内置常量名称代替数值.xlsm <span style='color:#111;'>19.38KB</span>","children":null,"spread":false},{"title":"10-2代码缩进.xlsm <span style='color:#111;'>14.20KB</span>","children":null,"spread":false},{"title":"10-4并闭屏幕更新提升工作效率.xlsm <span style='color:#111;'>155.64KB</span>","children":null,"spread":false},{"title":"10-5使用With提升代码的书写效率和执行效率.xlsm <span style='color:#111;'>14.73KB</span>","children":null,"spread":false},{"title":"10-6对小于B1的单元格填充背景.xlsm <span style='color:#111;'>188.14KB</span>","children":null,"spread":false},{"title":"10-1代码分行.xlsm <span style='color:#111;'>18.02KB</span>","children":null,"spread":false},{"title":"10-9使用Replace简化字符串连接.xlsm <span style='color:#111;'>14.79KB</span>","children":null,"spread":false},{"title":"10-8用Instr函数简化字符串判断.xlsm <span style='color:#111;'>14.59KB</span>","children":null,"spread":false},{"title":"10-7使用带$的函数优化程序.xlsm <span style='color:#111;'>15.09KB</span>","children":null,"spread":false},{"title":"6-4删除活动单元格的值.xlsm <span style='color:#111;'>15.75KB</span>","children":null,"spread":false},{"title":"6-5将第1工作表的已用区域的值复制到第2个工作表.xlsm <span style='color:#111;'>20.25KB</span>","children":null,"spread":false},{"title":"6-6将三个工作表的细明数据复制到总表中.xlsm <span style='color:#111;'>23.72KB</span>","children":null,"spread":false},{"title":"鼠标移过单元格时在状态栏显示地址.xlsm <span style='color:#111;'>19.79KB</span>","children":null,"spread":false},{"title":"6-11DrawingObjects应用.xlsm <span style='color:#111;'>63.97KB</span>","children":null,"spread":false},{"title":"6-2With语句的嵌套应用.xlsm <span style='color:#111;'>15.30KB</span>","children":null,"spread":false},{"title":"6-8Range.End属性的应用.xlsm <span style='color:#111;'>14.72KB</span>","children":null,"spread":false},{"title":"6-7在指定区域双击录入日期.xlsm <span style='color:#111;'>15.85KB</span>","children":null,"spread":false},{"title":"6-3颜色编码与颜色的对应关系.xlsm <span style='color:#111;'>16.70KB</span>","children":null,"spread":false},{"title":"6-1使用对象变量和With语句简化引用.xlsm <span style='color:#111;'>16.08KB</span>","children":null,"spread":false},{"title":"6-9获取指定坐标下的对象.xlsm <span style='color:#111;'>146.69KB</span>","children":null,"spread":false},{"title":"6-10图形对象名称.xlsm <span style='color:#111;'>135.28KB</span>","children":null,"spread":false},{"title":"四车间.xlsx <span style='color:#111;'>11.67KB</span>","children":null,"spread":false},{"title":"汇总表.xlsm <span style='color:#111;'>16.64KB</span>","children":null,"spread":false},{"title":"二车间.xlsx <span style='color:#111;'>11.76KB</span>","children":null,"spread":false},{"title":"三车间.xlsx <span style='color:#111;'>11.73KB</span>","children":null,"spread":false},{"title":"一车间.xlsx <span style='color:#111;'>11.67KB</span>","children":null,"spread":false},{"title":"1-1一键提取身份证信息.xlsm <span style='color:#111;'>115.92KB</span>","children":null,"spread":false},{"title":"数据录入助手.xlsm <span style='color:#111;'>37.55KB</span>","children":null,"spread":false},{"title":"数据录入助手.xlam <span style='color:#111;'>50.88KB</span>","children":null,"spread":false},{"title":"测试表.xlsx <span style='color:#111;'>10.47KB</span>","children":null,"spread":false},{"title":"8-4快速录入出勤表.xlsm <span style='color:#111;'>18.72KB</span>","children":null,"spread":false},{"title":"8-1自动宏.xlsm <span style='color:#111;'>15.11KB</span>","children":null,"spread":false},{"title":"8-3在状态栏提示最大值的单元格地址.xlsm <span style='color:#111;'>14.74KB</span>","children":null,"spread":false},{"title":"8-12阅读模式.xlsm <span style='color:#111;'>21.88KB</span>","children":null,"spread":false},{"title":"8-10自动设置工作表页眉.xlsm <span style='color:#111;'>13.66KB</span>","children":null,"spread":false},{"title":"8-8自动跳过公式区.xlsm <span style='color:#111;'>21.02KB</span>","children":null,"spread":false},{"title":"8-6在批注中存放所有修改记录.xlsm <span style='color:#111;'>14.96KB</span>","children":null,"spread":false},{"title":"8-13启用宏才能开启的工作簿.xlsm <span style='color:#111;'>19.92KB</span>","children":null,"spread":false},{"title":"8-7利用数字简化公司名称输入.xlsm <span style='color:#111;'>15.75KB</span>","children":null,"spread":false},{"title":"8-5选区字符统计.xlsm <span style='color:#111;'>19.44KB</span>","children":null,"spread":false},{"title":"8-11未汇总则禁止关闭工作簿.xlsm <span style='color:#111;'>22.07KB</span>","children":null,"spread":false},{"title":"8-2启用与禁用事件.xlsm <span style='color:#111;'>17.54KB</span>","children":null,"spread":false},{"title":"8-9背景着色.xlsm <span style='color:#111;'>15.42KB</span>","children":null,"spread":false},{"title":"5-2正确指定变量类型的优势.xlsm <span style='color:#111;'>19.04KB</span>","children":null,"spread":false},{"title":"5-4变量的作用域.xlsm <span style='color:#111;'>14.66KB</span>","children":null,"spread":false},{"title":"5-1三个数据类型错误案例.xlsm <span style='color:#111;'>14.58KB</span>","children":null,"spread":false},{"title":"5-3正确指定变量类型的优势2.xlsm <span style='color:#111;'>17.46KB</span>","children":null,"spread":false},{"title":"5-5三种错误的对象变量赋值方式.xlsm <span style='color:#111;'>15.79KB</span>","children":null,"spread":false},{"title":"5-6使用对象变量提升程序效率.xlsm <span style='color:#111;'>16.91KB</span>","children":null,"spread":false},{"title":"16-9按条件合并.xlsm <span style='color:#111;'>17.02KB</span>","children":null,"spread":false},{"title":"16-1根据业绩计算奖金.xlsm <span style='color:#111;'>16.23KB</span>","children":null,"spread":false},{"title":"16-7获取极值的地址.xlsm <span style='color:#111;'>19.00KB</span>","children":null,"spread":false},{"title":"~$16-9按条件合并.xlsm <span style='color:#111;'>165B</span>","children":null,"spread":false},{"title":"16-11按颜色对区域进行条件求和.xlsm <span style='color:#111;'>18.95KB</span>","children":null,"spread":false},{"title":"16-3计算当前页数.xlsm <span style='color:#111;'>17.17KB</span>","children":null,"spread":false},{"title":"16-12按颜色从左向向右查找所有数据.xlsm <span style='color:#111;'>22.45KB</span>","children":null,"spread":false},{"title":"16-10合并区域或数组的值.xlsm <span style='color:#111;'>19.25KB</span>","children":null,"spread":false},{"title":"16-4根据合并单元格合计数据.xlsm <span style='color:#111;'>15.95KB</span>","children":null,"spread":false},{"title":"16-13合计分隔符左边的所有数值.xlsm <span style='color:#111;'>15.78KB</span>","children":null,"spread":false},{"title":"16-2判断活动工作簿中是否有图形对象.xlsm <span style='color:#111;'>648.80KB</span>","children":null,"spread":false},{"title":"16-5创建工作表目录.xlsm <span style='color:#111;'>4.90MB</span>","children":null,"spread":false},{"title":"16-6分段提取数值.xlsm <span style='color:#111;'>17.38KB</span>","children":null,"spread":false},{"title":"16-14为函数分类及添加说明.xlsm <span style='color:#111;'>17.91KB</span>","children":null,"spread":false},{"title":"16-8对前N大值求和.xlsm <span style='color:#111;'>16.23KB</span>","children":null,"spread":false},{"title":"2-2调用子过程的五种方法.xlsm <span style='color:#111;'>18.31KB</span>","children":null,"spread":false},{"title":"2-1录制宏.xlsm <span style='color:#111;'>428.16KB</span>","children":null,"spread":false},{"title":"14-14贪婪匹配与惰性匹配.xlsm <span style='color:#111;'>20.18KB</span>","children":null,"spread":false},{"title":"14-2两个正则表达式模板.xlsm <span style='color:#111;'>17.73KB</span>","children":null,"spread":false},{"title":"14-10按指定长度匹配任意字符.xlsm <span style='color:#111;'>13.90KB</span>","children":null,"spread":false},{"title":"14-5贪婪匹配与惰性匹配.xlsm <span style='color:#111;'>17.43KB</span>","children":null,"spread":false},{"title":"14-1前期绑定与后期绑定.xlsm <span style='color:#111;'>18.95KB</span>","children":null,"spread":false},{"title":"14-21返回文件名与路径.xlsm <span style='color:#111;'>18.10KB</span>","children":null,"spread":false},{"title":"14-20获取Email地址.xlsm <span style='color:#111;'>17.44KB</span>","children":null,"spread":false},{"title":"14-11正向预查.xlsm <span style='color:#111;'>14.07KB</span>","children":null,"spread":false},{"title":"14-13负正向预查.xlsm <span style='color:#111;'>17.24KB</span>","children":null,"spread":false},{"title":"14-12正向预查应用2.xlsm <span style='color:#111;'>19.98KB</span>","children":null,"spread":false},{"title":"14-23分列的高级应用.xlsm <span style='color:#111;'>19.88KB</span>","children":null,"spread":false},{"title":"14-3删除字符串的所有数字.xlsm <span style='color:#111;'>16.38KB</span>","children":null,"spread":false},{"title":"14-18去除首尾空白字符.xlsm <span style='color:#111;'>14.49KB</span>","children":null,"spread":false},{"title":"14-4提取字符串的所有数字.xlsm <span style='color:#111;'>17.50KB</span>","children":null,"spread":false},{"title":"14-15汇总采购金额.xlsm <span style='color:#111;'>17.72KB</span>","children":null,"spread":false},{"title":"14-19数字分列.xlsm <span style='color:#111;'>19.55KB</span>","children":null,"spread":false},{"title":"14-24标示重复字词.xlsm <span style='color:#111;'>27.16KB</span>","children":null,"spread":false},{"title":"14-17汇总括号中的数值.xlsm <span style='color:#111;'>20.07KB</span>","children":null,"spread":false},{"title":"14-22仅汇总人民币.xlsm <span style='color:#111;'>18.73KB</span>","children":null,"spread":false},{"title":"14-16计算建筑面积.xlsm <span style='color:#111;'>19.14KB</span>","children":null,"spread":false},{"title":"14-9位置匹配.xlsm <span style='color:#111;'>12.96KB</span>","children":null,"spread":false},{"title":"14-6认识可选匹配.xlsm <span style='color:#111;'>14.14KB</span>","children":null,"spread":false},{"title":"14-7限量匹配.xlsm <span style='color:#111;'>14.45KB</span>","children":null,"spread":false},{"title":"14-8转换电话薄格式.xlsm <span style='color:#111;'>17.22KB</span>","children":null,"spread":false},{"title":"17-15设计启动LOGO.xlsm <span style='color:#111;'>150.40KB</span>","children":null,"spread":false},{"title":"17-10设计超链接.xlsm <span style='color:#111;'>21.53KB</span>","children":null,"spread":false},{"title":"17-5播放Flash动画.xlsm <span style='color:#111;'>35.25KB</span>","children":null,"spread":false},{"title":"1.jpg <span style='color:#111;'>1.33KB</span>","children":null,"spread":false},{"title":"17-1Excel5.0对话框.xlsm <span style='color:#111;'>16.68KB</span>","children":null,"spread":false},{"title":"17-17设计计划任务向导.xlsm <span style='color:#111;'>28.25KB</span>","children":null,"spread":false},{"title":"17-20多工作表录入.xlsm <span style='color:#111;'>32.02KB</span>","children":null,"spread":false},{"title":"17-3使用代码为命令按钮指定Picture属性.xlsm <span style='color:#111;'>14.12KB</span>","children":null,"spread":false},{"title":"17-7双击时关闭窗体.xlsm <span style='color:#111;'>19.10KB</span>","children":null,"spread":false},{"title":"17-14为控件设置帮助信息.xlsm <span style='color:#111;'>22.12KB</span>","children":null,"spread":false},{"title":"......","children":null,"spread":false},{"title":" <span style='color:steelblue;'>文件过多，未全部展示</span>","children":null,"spread":false}],"spread":true}]