Reply to thread

Message: [QUOTE="Joy, post: 4899354"] in our macros, we use map to import data from csv file to MS project. we have: FileOpen name:=GetTempDir & "\uExport.csv", FormatID:="MSProject.CSV", Merge:=2, map:="Export Map" and sometimes, when using MS 2007, we encoutered Run-time error : Method 'FileOpen' of object '_MSProject' failed The issue does not happen always, but sometimes. And if I click 'End', and next time, if I run the macros again, it will ask me "There was a problem opening this project last time. Do you want to attempt a repair?" Yes/No. I have to choose No. This makes the macros really bad for users. I am wondering whether there is a better way to deal with FileOpen? Then when we run macros, it can gracefully import data from csv file. [/QUOTE]