Excel SaveAs problem

[wasishincar]

Hi all,

I wrote a small app, which could read text file and fill the data from
text file to a newly created excel file. It works fine on my computer,
but did not succeed on someone's. I caught an exception which told it
occurred when "trying to read or write protected memory. It usually
means the memory was damaged". What did I need to check? The account is
administrator, and it should be fine to write file at any place in that
PC.

Here is a my code. Thanks for any replying.

Excel.Applicati on ExcelObj = new
Microsoft.Offic e.Interop.Excel .Application();

void func1(string xlsfilename)
{
// See if the Excel Application Object was successfully constructed
if (ExcelObj == null)
{
MessageBox.Show ("ERROR: EXCEL couldn't be started!");
return;
}

try
{
string filename = xlsfilename;
Excel.Workbook wb = ExcelObj.Workbo oks.Add(Type.Mi ssing);

// get the collection of sheets in the workbook
Excel.Sheets sheets = wb.Worksheets;
Excel.Worksheet worksheet;

worksheet = (Excel.Workshee t)sheets.get_It em(1);
worksheet.Name = "Data";

//do some data processing

wb.SaveAs( filename , Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing,
Excel.XlSaveAsA ccessMode.xlNoC hange, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing);
wb.Close(false, Type.Missing, false);
}
catch(Exception ex)
{
MessageBox.Show ("Message: " + ex.Message + "\nSource: " + ex.Source
+ "\nTrack: "
+ ex.StackTrace);
}

ExcelObj.Workbo oks.Close();
ExcelObj.Quit() ;
ExcelObj = null;

GC.Collect();
}

[Steve Barnett]

I just copied your code in to one of my apps and it works fine. The most
likely issue I could think of is a mismatch between the version of Excel
you're referencing in the IDE compared to the version you're executing
against.

Sorry I can't be more help.

Steve
"wasishinca r" <ad*********@gm ail.comwrote in message
news:11******** **************@ d34g2000cwd.goo glegroups.com.. .

Hi all,

I wrote a small app, which could read text file and fill the data from
text file to a newly created excel file. It works fine on my computer,
but did not succeed on someone's. I caught an exception which told it
occurred when "trying to read or write protected memory. It usually
means the memory was damaged". What did I need to check? The account is
administrator, and it should be fine to write file at any place in that
PC.

Here is a my code. Thanks for any replying.

Excel.Applicati on ExcelObj = new
Microsoft.Offic e.Interop.Excel .Application();

void func1(string xlsfilename)
{
// See if the Excel Application Object was successfully constructed
if (ExcelObj == null)
{
MessageBox.Show ("ERROR: EXCEL couldn't be started!");
return;
}

try
{
string filename = xlsfilename;
Excel.Workbook wb = ExcelObj.Workbo oks.Add(Type.Mi ssing);

// get the collection of sheets in the workbook
Excel.Sheets sheets = wb.Worksheets;
Excel.Worksheet worksheet;

worksheet = (Excel.Workshee t)sheets.get_It em(1);
worksheet.Name = "Data";

//do some data processing

wb.SaveAs( filename , Type.Missing, Type.Missing, Type.Missing,
Type.Missing,
Type.Missing,
Excel.XlSaveAsA ccessMode.xlNoC hange, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing);
wb.Close(false, Type.Missing, false);
}
catch(Exception ex)
{
MessageBox.Show ("Message: " + ex.Message + "\nSource: " + ex.Source
+ "\nTrack: "
+ ex.StackTrace);
}

ExcelObj.Workbo oks.Close();
ExcelObj.Quit() ;
ExcelObj = null;

GC.Collect();
}