Problem importing from excel in MSP2003 (Work well in MSP2000)

[kanthongv]

Hello,

I have a compatibility problem with MS Project 2003. I have one macro to
generate the MS Project Plan. This macro has three sources of information.
These sources are three ".CSV" files with the tasks, resources and assignment
information, and I have three mapping for each of them. The following piece
of code shows how data is imported:


...

FileOpen Name:= Path & Tasks, _
ReadOnly:=False, _
Map:="All_Tasks"

FileOpen Name:= Path + Resources, _
ReadOnly:=False, _
Map:="All_Resources"

FileOpen Name:= Path + Assignments, _
ReadOnly:=False, _
Map:="All_Assignments"
...


The import orden is very important, and this can't be changed. I made
different test and I found that the problem appears when the last
import(Assignment) is executed.

I think that the map of "All_Assignments" is not mapping correctly, because
when I correct this and I didn't do any changes in the mapping, and then in
the "Import Wizard - Map Options" I picked the button "Finish", all the value
tasks in the "work" column look like fine minus only one of them, so I edit
the Map again and when I reached the "Map Options" in the "Import Wizard" and
I picked "Finish" button, before that all the value tasks look like fine.

This macro works fine in the MS Project 98 and Ms Project 2000.

There is a well known fixed problem here?

I've installed the service pack 1 however the problem stills continue.



Thanks in advance.
Kanthong Vannasaeng