Range.ExportFragment equivilent in Excel (& PPT)?

[David Thielen]

Hi;

Word 2007/2010 has Range.ExportFragment.

Is there an equivilent for XLSX (& PPTX - have not looked at PPT yet)?

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Colbert Zhou [MSFT]]

Hello Dave,

I researched this a lot on the web. Although someone tells that the same
thing for ExportFragment of Excel is SaveCopyAs method
http://blogs.msdn.com/dmahugh/archive/2008/01/11/open-xml-links-for-01-11-20
07.aspx
But based on my understanding, they are a little different. SaveCopyAs
method cannot only save a specified range to a new workbook, so it is not
about a fragment.

So my conclusion is there is not such an equivilent method in Excel and
PowerPoint. But to achieve the ExportFragment objective, we can follow
another idea you raised in the newsgroup "Creating a workbook, pasting to
it, close it - all hidden". I have replied with codes there. Could you
please check and if you need further help on this, we can follow up in that
thread.

Have a nice day!


Best regards,
Ji Zhou
MSDN Subscriber Support in Forum