PpSaveAsFileType values for office 2003 with Office 2007 Converter

R

Rohan Salt

Does anyone know what the PpSaveAsFileTypes value are in Powerpoint when the
office 2007 converters pack is installed?

Can I enumerate the types from VBA...?
 
S

Steve Rindsberg

Rohan Salt said:
Does anyone know what the PpSaveAsFileTypes value are in Powerpoint when the
office 2007 converters pack is installed?

Can I enumerate the types from VBA...?

You can see them in the Object Browser from within the IDE if you just need to
look something up.

As far as I know, the compatibility pack doesn't update the object model, but
you could start by using the object browser to find the highest assigned
numeric value then try SaveAs with higher values.
 
R

Rohan Salt

Steve,

I have got a bit further than yesterday..

Word and Excel allow you to save a document in 2007 format via the VBA
SaveAs/Save commands by specifying the appropriate file type (in excel 2003
the file type is the same as excel 2007 (ie 51) , In Word 2003, its 100(the
number for the first installed text converter and different to the 2007
setting). You can work out this setting by recording a marco to obtain the
value.

This approach does not work for Powerpoint as tryring to records a macro
with a Save As command and selecting pptx crashes powerpoint (or a least
stops and tells you "something bad" has happened and to restart power point)

By changing the default save format in Power Point and hacking the registry,
I have determined the internal value being used is "21" (its 24 in PP2007!).
When you use this value in VBA, the Save As command executes but does
nothing(ie doesnt save the document but also doesn't generate an error!)

So the real question, Is it possible for PowerPoint to access Converters
from VBA's SaveAs command
 
S

Steve Rindsberg

By changing the default save format in Power Point and hacking the registry,
I have determined the internal value being used is "21" (its 24 in PP2007!).
When you use this value in VBA, the Save As command executes but does
nothing(ie doesnt save the document but also doesn't generate an error!)

According to the object browser in both PPT 2003 with and w/o the compat pack
installed, 21 is the value for TIFF files, not any of the new Office 2007
types, so I'm not surprised that didn't work for you.

FWIW, recording a macro makes PPT 2003 unhappy here too, in the same way as you
describe.
So the real question, Is it possible for PowerPoint to access Converters
from VBA's SaveAs command

I don't think it is.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top