PDA

View Full Version : Solved: open a MSP file in excel



Pete
09-12-2008, 05:43 AM
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

Pete
09-12-2008, 05:43 AM
for the purpose of this excerise the MSP file can be a blank template.....

SherryO
10-08-2008, 10:53 AM
Have you tried doing a SaveAs from MSProject to .xls format, then opening the the file in Excel?

forwolf
10-17-2008, 01:30 PM
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?