Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving workbook in code
Hi I am Rajesh. I am stuck in a big big problem. PLease help me out... I want to open a work book in a xls file using C# code in the page-load event of an ASP.NET page, write two values into two cells (using code), save that workbook and redirect the browser to show that xls file But when the workbook.save statement is being executed, a dialog is being thrown at me saying that "A file with name <file1.xls already exists. Do u want to replace it?" 1) How can I save that xls file without that dialog? And after saving when I redirect the browser to show that xls file, that is becoming a read-only copy. I think this is due to an Excel.exe instance running already in memory. 2) How can I make that xls file a writable one in when it is displayed in browser? Please help me..... Many Many thanks in advance Rajesh -- harkit ------------------------------------------------------------------------ harkit's Profile: http://www.excelforum.com/member.php...o&userid=25764 View this thread: http://www.excelforum.com/showthread...hreadid=391732 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving workbook in code
Rajesh,
For your question #1, the usual method is to use this befo Application.DisplayAlerts = False and use this after Application.DisplayAlerts = True where Application is the Excel object, so change to reflect your actual coding. HTH, Bernie MS Excel MVP "harkit" wrote in message ... Hi I am Rajesh. I am stuck in a big big problem. PLease help me out... I want to open a work book in a xls file using C# code in the page-load event of an ASP.NET page, write two values into two cells (using code), save that workbook and redirect the browser to show that xls file But when the workbook.save statement is being executed, a dialog is being thrown at me saying that "A file with name <file1.xls already exists. Do u want to replace it?" 1) How can I save that xls file without that dialog? And after saving when I redirect the browser to show that xls file, that is becoming a read-only copy. I think this is due to an Excel.exe instance running already in memory. 2) How can I make that xls file a writable one in when it is displayed in browser? Please help me..... Many Many thanks in advance Rajesh -- harkit ------------------------------------------------------------------------ harkit's Profile: http://www.excelforum.com/member.php...o&userid=25764 View this thread: http://www.excelforum.com/showthread...hreadid=391732 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatically saving workbook (or worksheet) without the code | Excel Programming | |||
Saving a Workbook: Forcing User to Rename before Saving | Excel Programming | |||
ChartCalculate code causing error when saving workbook | Excel Programming | |||
SAVING A COPY OF WORKBOOK W/O THE CODE IN IT | Excel Programming | |||
Saving a Workbook without code | Excel Programming |