Solved: open a MSP file in excel

See attached workbook(s)
Hi

Do not have a clue in how to complete the following steps.

I need to open the following MSp file in MS Excel using a macro button.

so the steps are as follows:

1. opem MS excel, click macro button to import MS P file

in order to edit file in MS excel

verison 2003

for the purpose of this excerise the MSP file can be a blank template.....

Have you tried doing a SaveAs from MSProject to .xls format, then opening the the file in Excel?

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?