-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules