VBA宏+计划冲突 [英] VBA Macro + Schedule Conflict
问题描述
我写了一个宏,它在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屋!