Export Sheet Excel to MS Project

[aelmalki]

Hello,

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

Thank you in advance

 

[JulieS]

Hello aelmalki,

Try:
File > Save As
From the Save as Type drop-down at the bottom, select Microsoft
Excel Workbook.
Click Save.

The export wizard will launch. Follow the steps in the wizard.

Step through the process and post back with more questions as you
need more information.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

 

[Dytham]

Either the question was the wrong way around, or the answer was.

Question concerned "method to export data FROM an Excel Sheet TO MS Project"

In MSProject, do File / Open then change File Type to Excel (.xls)

As Julie said, then use the Wizard.

Chas.

 

[aelmalki]

Hello Julie,

Thank's for your reply.

But I want to know how can I do this import with a VBA macro, im sorr
I forget to specify in my post.

Thank you very much

 

[dytham]

Try doing it manually first to create the map that you want, then do
it again manually whilst recording as a macro, naming that map. See
the VBA code produced.

Posts about VBA are more pertinent in Microsoft Project Developer
forum.

Chas.

 

[JulieS]

Sorry -- it was the answer that was wrong way around. Not enough
coffee, clearly.

 

[aelmalki]

Hi,

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.

 

[JulieS]

Hello aelmalki,

Do you have a reference to the Microsoft Project object library in
Excel?

Julie