Turn off Export Map Wizard

[MED]

I am trying to write a Macro to read in several Project plans and save them
each in their own MS-Excel Workbook. I can not find a way to turn off the
Export Map Wizard and just choose a predefined and saved Task Export Map. I
need help working through this problem.

 

[JackD]

Did you try using the macro recorder and record yourself doing this?
This is what the result is:

FileSaveAs Name:="C:\foo.xls", FormatID:="MSProject.XLS5", map:="Task
""Export Table"" map"

Replace the _ Task "Export Table" map _ with whatever the name of the
pre-defined map is.

Note that the map name must be in quotation marks and any quotation marks in
the name must have an extra quotation mark in front of them.

 

[Gérard Ducouret]

Hello MEd,
Quite simple : that's a VBA macro that you can record. Just add the
Application.Alerts False method

Gérard Ducouret

Example :
Sub Mapping()

' Macro Recorded 21/01/05 00:22 by Gérard Ducouret.
Application.Alerts False
FileSaveAs Name:="C:\Documents and Settings\PragmaAdm\Mes
documents\PragmaSoft.xls", FormatID:="MSProject.XLS5", map:="Top Level Tasks
list"
End Sub