Excel 2000 and TextBoxes

[Giulio Cifelli]

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!

 

[Chip Pearson]

Guilo,

Are you sure the text boxes are from the Drawing toolbar, or are
the from the (ActiveX) Controls toolbar?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Giulio Cifelli]

The text boxes (buttons and labels as well for that matter) are defined
within the Worksheet. This is a higly interactive Excel workbook with
lots of macros. When launched standalone, it is an application in
itself. What I am trying to do is to change the labels of some of the
text boxes and buttons based on the data that is being outputted from
the C# program that I am writing.

Thanks,

Giulio.

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

 

[Chip Pearson]

Excel has two sets of controls which can be used on worksheets.
First, those from the Forms and Drawing toolbars, and, second,
those from the Controls toolbar. Which controls are you using on
the worksheet? The methods for accessing a control depends on
which type (Forms command bar or Controls command bar) the
control happens to be. I don't know C#, but the access methods
will be different for the two types.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Giulio Cifelli]

Chip,

The worksheet is using the controls from the Forms toolbar.

Thanks,

Giulio.




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

 

[Giulio Cifelli]

I am still having the problem... could somebody help.

Thanks in advance,

Giulio.


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