your code commented out the "Set newProj = pjApp.Projects.Add" which creates a project so that the subsequent code can successfully "newProj.Tasks.Add ("My First Task")"

The code is contrary to your step 1 which states "... import MS P file"; the code creates a project file and adds data to the project file. Do you want to import a file (into xl) or do you want to create a new project file and populate it with xl data using xl VBA?