On Error go to the next desired operation instead of next line

How can I make this code For Each wb In wbC If InStr(wb.BuiltinDocumentProperties("keywords").value(), "MyApplicationSet") = 0 Then On Error Resume Next End If Call OverTimeSave(wb) Next so when the current workbook is not part of the system - it skips that one workbook (without saving it) and iterates to the next workbook? Is that code correct, because I am not sure the `On Error Resume Next` will do the work here, as I read, it will just go to the next statement, which means it will call the save function on the particular workbook, which is not part of my system. I want it like: if there's error - do nothing and iterate to the next workbook.

以上就是On Error go to the next desired operation instead of next line的详细内容,更多请关注web前端其它相关文章!

赞(0) 打赏
未经允许不得转载:web前端首页 » excel

评论 抢沙发

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址

前端开发相关广告投放 更专业 更精准

联系我们

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏