Excel workboox.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
 

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

Similar Threads

inlineShape.OLEFormat.Activate() command fails for excel file 0
Excel workbook.saveas freezes program 2
How to reduce excel file size having pivot tables 0
multiple instances of excel process gets created in the task manager 0
Calling workbook.saveas depending on excel version 1
How to save and close multiple Excel applications? 1
Identifying anc saving workbooks from more than one Excel applicat 0
Excel 2000 open using C# error - Unable to cast COM object of type 1

Top