VBA宏+计划冲突 [英] VBA Macro + Schedule Conflict

查看:110
本文介绍了VBA宏+计划冲突的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我写了一个宏,它在MSP的开始和结束日期做了一些更改,反过来这个代码给我弹出计划冲突,如果我说"继续"
然后宏运行,现在这个宏非常冗长,我不希望用户坐在屏幕前点击弹出窗口,所以我写了一个在服务器上运行的宏。

I have written a macro, which does some changes in the MSP's Start and finish Date , in turn this code give me popups on schedule conflicts and if i say "continue" then macro runs, now this macro is quite lengthy, i dont want user to sit in front of the screen and click on the Popups, so i have written a Macro which runs on the server.

因此需要自动点击"继续"按钮或跳过该弹出窗口并默认接受所有计划冲突。

So the need comes to either automatically click on the continue button or skip that Popup and Accept all the schedule conflict by default.

无论如何要实现同样??

is there anyway to achieve the same??

谢谢,Parth

推荐答案

你试过吗? ;接下来的错误恢复" ? 这适用于各种编程错误,但我不知道这是否适用于安排冲突。 值得一试。

have you tried "on error resume next" ?  that works for various programming errors but I don't know if that will work for scheduling conflicts.  worth a try tho.

GMAN


这篇关于VBA宏+计划冲突的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆