View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ryan[_12_] Ryan[_12_] is offline
external usenet poster
 
Posts: 5
Default Calling workbook.saveas depending on excel version

Hi,

I am working on some software that integrates an excel workbook. I am
having a problem calling the workbook.saveas method. I am developing on
XP with excel 2003, but i need this code to work with excel 2000.
Apparently excel 2000 requires saveas to have 10 arguments while excel
2003 requires 12 arguments. Ideally I would have something like this:

if (System.String.Compare(_app.Version,"10") < 0)
{
//Office 2000
_wb.SaveAs(_strFilename, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing, Type.Missing,
Type.Missing);
}
else
{
//Office XP
_wb.SaveAs(_strFilename, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing, Type.Missing,
Type.Missing, Type.Missing,Type.Missing);
}

However I cannot compile this on my XP machine because it says "no
overload for method saveas takes 10 arguments" at the first SaveAs
call.

Help!