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!