Excel workbook.saveas freezes program

R

Ryan

In C# I create and open an excel spreadsheet, populate it with data,
and then attempt to save it. This all works fine on my XP SP2 machine
with Excel 2003. However when I try to run it on Windows 2000 with
Excel 2000, the code gets stuck on _wb.Saveas (see code snippet below).

_app = new Excel.Application();
_wb = _app.Workbooks.Add(Type.Missing);
_ws = (Excel._Worksheet) _wb.Sheets.get_Item(1);

//populate the worksheet with data

_wb.SaveAs(aFileName, Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing,
Excel.XlSaveAsAccessMode.xlNoChange,Type.Missing, Type.Missing,
Type.Missing, Type.Missing,Type.Missing);

Thanks,
Ryan
 
N

NickHK

Ryan,
Excel 2K only has 10 arguments to .SaveAs., but it appears Excel 2003 has
12.
You should make your code compatible with the oldest version you intend to
support.

NickHK
 
R

Ryan

Sorry this issue got sidetracked.

Thanks alot, that is the problem.

Do you know if there's somewhere that I can find documentation about
the differences between the versions of office from a programmer's
perspective?

Thanks.
 

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