I have some code that opens a MS Project file and converts it to an MS Access Database after the user selects a file. Once the file is converted, code then runs a macro that will import the MS Project Data from the MS Access Databse into a new MS Access application for processing. The problem I am having is that the macro starts to run before the conversion is complete and causes an error. (See below code... the macro starts to run before the save project processing is complete)

What is the easiest way to code this such that the macro does not run until after the code is complete. (I do not want to use a message box that the user needs to enter OK to continue)


N = Forms!frmExplorer!lbxFiles.Value
SendKeys "