Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
office program freezes for about 1 min when doing a save as | Excel Discussion (Misc queries) | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Excel freezes | Excel Discussion (Misc queries) | |||
When i delete rows the program freezes | Excel Discussion (Misc queries) | |||
Excel Freezes | Excel Programming |