J
Joy
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.
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.