FileOpen issue!!

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top