ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel workboox.saveas freezes program (https://www.excelbanter.com/excel-programming/367700-excel-workboox-saveas-freezes-program.html)

Ryan[_12_]

Excel workboox.saveas freezes program
 
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


Ryan[_12_]

Excel workboox.saveas freezes program
 
Sorry about the double post.

Use the newer one pls (not this one).

Ryan wrote:
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




All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com