View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Excel workbook.saveas freezes program

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

"Ryan" wrote in message
oups.com...
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