Hi
Part of my code imports data from an Excel file into Project...
As my Excel file does not have a project start date in it, a warning box comes up, which just needs 'ok'ing, because my code then goes on to set the start date correctly.
I need a way of clearing the box/ preventing it from appearing. Using send keys doesn't work, because the code doesn't move onto the next statement (ie the Sendkeys) until the box is cleared.
Can anyone help?
TIA
Jonathan
Part of my code imports data from an Excel file into Project...
Code:
FileOpen Name:=strExcel, ReadOnly:=False, Merge:=0, FormatID:="MSProject.XLS5", map:="TaskExportForVisio"
As my Excel file does not have a project start date in it, a warning box comes up, which just needs 'ok'ing, because my code then goes on to set the start date correctly.
I need a way of clearing the box/ preventing it from appearing. Using send keys doesn't work, because the code doesn't move onto the next statement (ie the Sendkeys) until the box is cleared.
Can anyone help?
TIA
Jonathan