Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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" wrote in message ... 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! |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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! |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 and TextBoxes
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
unknown textboxes in excel 2007 | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Code-signing certificate problems in Excel 2000 with Windows 2000 | Excel Programming | |||
Excel Textboxes | Excel Programming |