Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Unable to clear 'ok' box when importing Excel file into Project

Status
Not open for further replies.

xplo5iv

Technical User
Jan 5, 2005
75
0
0
GB
Hi

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top