Export Map to Excel 97

[Steve Scott]

I need to be able to ensure when I File/SaveAs/Excel workbook that Project
2000 will save the excel file in 97 version not excel 2000. Does anyone know
how this can be specified in a macro?

 

[JackD]

The easiest way to do this is turn on the macro recorder and save the file.
Then look at the code.

 

[Steve Scott]

Hi,

The relevant piece of code in the FileSaveaAs statement is:
FormatID:="MSProject.XLS5"

This would appear to save the excel file to 97/2000 version. Where can I get
a ;list of other possible values for different Excel versions?

Thanks

 

[JackD]

I don't think that there are other possible values if they are not shown in
the save-as list. There is a remote chance that perhaps they deleted older
versions from the list, but did not completely remove the functionality so
you could try and see if
FormatID:="MSProject.XLS4" would work, but I doubt that you will find it
documented anywhere.
If I recall correctly Excel97 was the name for Excel 5.

 

[Steve Scott]

thanks, but it didn't work...I need this so that an Acceee 97 database can
read the exported xls file in first time whithout me having to reformat the
file in Excel first..I'll try the Access 97 newsgroups to see if they have
any ideas.

Thanks

Steve

 

[JackD]

I didn't really have much hope that it would.
Why don't you try exporting to an access database directly?
Though, with Access 97 you will have some difficulties. You need to have an
existing database to import into or it will save as access 2000 format.
I have to say, access 97 is getting a bit old...

 

[Steve Scott]

Trouble is with the Access mdb export is that it exports all the project
tables...I would like it to export just 1 table that is derived from the
fields in my export map.

...and yes my organisation is living in the dark ages with Access 97.

Rgds

Steve