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 |
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