index > Visual Studio Tools for Office > Excel 2007 file saving

Excel 2007 file saving

Hi, i'm having trouble saving excel file with .NET.

if i'm trying to save like this:

mBook - is a excel worksheet

this.mBook.SaveAs(filename, mv, mv, mv, mv, mv, XlSaveAsAccessMode.xlExclusive, mv, mv, mv, mv);

i'm getting exception HRESULT: 0x800A03EC

when i'm saving the save workbook like this:

this.mBook.SaveCopyAs(filename);

everything is ok, except the fact, that file is saved in format, that older excel(for example 2000 or 2003) can't open.

i've tried to use different parameters on SaveAs function, for example change fileformat or access mode, but no luck :(

G.B.

I don't think Excel 2007 will be backward compatible with earlier versions of Excel, but do not quote me.

Need 2 be back @ MS - MS All the way! Follower since 1995 MS Super Evangelist| MSDN Forums Moderator

ahmedilyas

Hi GB

It's not clear what kind of environment you're working in. Is this VSTO? If not, then this isn't the right forum (even though Ahmed moved you here). You need to clarify what you're doing (VSTO, automation, classical Addin) then if it's not VSTO, post to the appropriate group, as listed in the "Please Read First" message at the top of this forum.

Ahmed is also wrong about Excel 2007 being compatible with older versions. It can be, under the right circumstances: you need to save in the older (compatible) file format OR you need to install the Conversion Pack on machines with the older version of Office.

If you haven't placed your SaveAs call in a try...catch block, then you may get more informative information about the error.

-- Cindy Meister (Word MVP)

Cindy Meister

Thanks Cindy, like i said, i was not sure at all :-) But thank-you for clearing it up

Need 2 be back @ MS - MS All the way! Follower since 1995 MS Super Evangelist| MSDN Forums Moderator

ahmedilyas

reply 4