Save Excel with a embeded PDF problem, can not open the PDF anymor

[top_top]

I use C# to generate a excel file. Inside it there is a embeded PDF file.

After I save the workbook using C# code, the PDF file is not clickable and
openable.

If I set the excel.visible = true when the sheet is generated, then the
excel application will popup. And if I save the sheet from there, the the
embeded PDF is works fine. I can double click it and then the adobe reader
opens PDF.

I also note that if I save the excel sheet in C#, the all the options in the
insert menu bar of that sheet is disable, e.g insert bar, picture, textbox,
all of these options are disabled.

Does anybody know what is wrong when I save the excel sheet.

Here is my code to save the excel sheet

workBook.SaveAs(this._reportFileName, XlFileFormat.xlExcel12, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
XlSaveAsAccessMode.xlShared, Type.Missing,
Type.Missing, Type.Missing, Type.Missing, Type.Missing);


Many thanks