VBA
简介
通过对象模型自动化 Office 应用,在过程内用 On Error 处理错误,并通过 Err 对象查看失败信息。
使用这门语言的成员
参与的讨论
Inherited workbooks and On Error Resume Next
Open almost any inherited workbook and the first line under the module header is the same. On Error Resume Next. Not around o…
An empty cell equals zero and the empty string
Inherited a macro that flags order rows with a zero quantity, and it flagged every blank row too. The check was If ws.Cells(r…