Consulting

Results 1 to 4 of 4

Thread: Solved: open a MSP file in excel

  1. #1
    VBAX Tutor
    Joined
    Aug 2007
    Posts
    294
    Location

    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

  2. #2
    VBAX Tutor
    Joined
    Aug 2007
    Posts
    294
    Location
    for the purpose of this excerise the MSP file can be a blank template.....

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

  4. #4
    VBAX Newbie
    Joined
    Oct 2008
    Posts
    1
    Location
    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
  •