I am using Excel 2000 and C#. I am able to open an Excel file, copy it
to a new file (based on user properties), and modify/add data to the
various worksheets. What I am stuck on is being able to change the text
for a text box defined within the Workbook.

I have tried many different variations and I always get the following
error: "Error: Exception from HRESULT: 0x800A03EC".

The code I am using is:

objExcelWS = (Interop.Excel.Worksheet)
objExcelWB.Worksheets[strSheetName];

objExcelWS.Unprotect(SHEET_PASSWORD);
Interop.Excel.TextBox objTxtBox = (Interop.Excel.TextBox)
objExcelWS.TextBoxes(strTextBoxName);


Has anybody experienced this problem? Any solutions?

Thanks in advance...

Giulio.

*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!