Results 1 to 11 of 11

Thread: Exporting Project files in form of Excel Sheet

  1. #1
    Join Date
    Oct 2009
    Posts
    2

    Exporting Project files in form of Excel Sheet

    Hello,

    I want to know how to use the FileSaveAs or FileOpen method to export data from an Excel Sheet to MS Project using a mapping.

    Thank you in advance.
    Last edited by aelmalki; 23-10-2009 at 02:53 PM.

  2. #2
    Join Date
    Oct 2005
    Posts
    44
    It is simple. You can just go to File and click on Save As and from there choose the Excel Workbook format. You can find that from the drop down box of Save As dialog box. Just hit on save and that's all. After that the file will not be created instantly. The export wizard will appear and you will have to follow some simple steps to get the final file. I am sure it will help you and work quiet properly. The wizard will guide you in proper manner to export all the contents that you are looking for.

  3. #3
    Join Date
    Oct 2009
    Posts
    2
    But I want to know how can I do this import with a VBA macro, im sorry I forget to specify in my post.

    Concerning my case, the question is about how to export sheet's Excel to MS Project executing an Excel VBA Macro (from Excel).

    The VBA code generated by using your solution in MS Project:
    Code:
    FileOpen Name:="C:\Export 20091023 1033.xls", ReadOnly:=False, Merge:=0, FormatID:="MSProject.XLS5", map:="Map1"
    I adapted this code in VBA Excel :
    Code:
    Set MSP = CreateObject("MSProject.Application")
    MSP.FileOpen Name:="C:\Export 20091023 1033.xls", FormatID:="MSProject.mpp.9", map:="Mappage_Listes_Tâches2"
    But i have an error.

    Do you have any idea???

    Thanks and best regards.

  4. #4
    Join Date
    Oct 2005
    Posts
    48
    I will recommend you to go with the manual process and I think it will really work. It will allow you to create a map that works in proper format. You can start by creating a macro first and then renaming the map. You can find a vba code based on the same on web easily. Because there are no major process involved. Also you can try to find some references led to Microsoft Project object library in excel which works really well.

  5. #5
    Join Date
    Dec 2006
    Posts
    489

    re: Exporting Project files in form of Excel Sheet

    It appears as though the other folks who have posted code have created a custom Import map in Microsoft project and simply call to that import map in their code.

    You can turn on the macro recorder in project and record the creation of the map or create the map before and call to the map in the code.

    Julie

  6. #6
    Join Date
    Sep 2005
    Posts
    53
    I think that is going to work well. But I am not sure about the same. I am going to provide a set of options that are mentioned above and will notify that whether it really works or not. There can be chances to get errors. I was expecting for a more detailed information on the same. I thought there will be some easy to use tool that will really work and provide the stuff that I am looking for. What are the more things that I can try out here.

  7. #7
    Join Date
    Dec 2006
    Posts
    489

    re: Exporting Project files in form of Excel Sheet

    Great. Glad to hear you were able to work it out.

  8. #8
    Join Date
    Oct 2005
    Posts
    31

    re: Exporting Project files in form of Excel Sheet

    JulieS,

    I need some help here to begin with a code that can allow me to automatically add a Project Object Library. Are you aware about the GUID which is available for Microsoft Project 2003. I am not able to find any information on the same. I think this is possible but would require more analysis on the step how it is going to work. Is there any other people available that has option to create or to add reference library through a manual process.

  9. #9
    Join Date
    Dec 2006
    Posts
    489

    re: Exporting Project files in form of Excel Sheet

    Sorry, no. Are you looking for the location of the Project 2003 object library? The best I can recommend is to look at the path in an installation of MS Project and include the full path to the OLB file.

  10. #10
    Join Date
    Oct 2005
    Posts
    32

    re: Exporting Project files in form of Excel Sheet

    I can find out some path at the bottom of reference library. I think something can be managed from there and it might work. I had went inside VBE tools and then clicked on references and hope it will be working well by clicking on Project Object Library. Can anyone put a more highlight on the same. I am also trying to find out some tools that can automate the process of exporting project files to excel. There are chances but it will be complicated.

  11. #11
    Join Date
    Dec 2006
    Posts
    489

    re: Exporting Project files in form of Excel Sheet

    You've run through my knowledge of VBA coding and then some. I suggest posting to the Microsoft Project Programming forum on TechNet.

    Best,
    Julie

Similar Threads

  1. Want to connect Excel sheet to other files worldwide
    By DEvOTeEL in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 07:16 PM
  2. Replies: 3
    Last Post: 01-06-2010, 04:31 AM
  3. Exporting from Project 2007 to Word 2003 or Excel 2003
    By Jasper W in forum Microsoft Project
    Replies: 5
    Last Post: 20-04-2009, 11:52 PM
  4. Replies: 1
    Last Post: 20-04-2009, 11:00 PM
  5. Replies: 3
    Last Post: 15-02-2008, 02:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,617,906.85314 seconds with 17 queries