Method 'FileOpen' of object '_MSProject' failed

[Joy]

I merge data in a csv file with my Project file. The merge key is UID, and
after merge, some data of a task gets updated. like Hyperlink field and some
Text fields.
I got the error message with Project 2007 occasionally.

2147417848
Method 'FileOpen' of object '_MSProject' failed

My codes:
Application.FileOpenEx Name:="C:\Documents and
Settings\<abc>\Desktop\1.csv", Merge:=2, FormatID:="MSProject.CSV",
Map:="Export Short Map"


I cannot see any problem with my Project file
each time I got it, I have to close the file, and run it again, and the
second time it usually succeeded.
I also notice that with some other Project files, I also got the error
sometimes.
What possible issues with my Project file?

thank you

 

[Jack Dahlgren]

Is the file already open? Maybe that is the problem?

-Jack Dahlgren

 

[Joy]

yeah

it is open

so if I use the method to merge data, the file should be closed first??

thanks

 

[Jack Dahlgren]

I don't know what your code is trying to do so I can't say if it needs to
close or not.

But just realize that you will generate an error if the file is open
already. Either check to see that it is open first or put in an error handler
so that your code can continue even if the file is open.

-Jack Dahlgren