Reply to thread

Message: [QUOTE="Problem importing from excel in MSP2003, post: 4886303"] 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 [/QUOTE]

Verification