I wants to create a chart and give its source value as "A1:B1,D1:F1,G1:H1", so I need to get the string of range address.
Thanks
How to get the range string of a worksheet.range object
Visual Studio Tools for Office
-
- Previous
- 1
- Excel 2003 and ListObjects (VSTO 2005) Hi. I need some advise with a little problem with my VSTO application. I have a excel document with a listobject. This listobject is bind with a datatable, that it's filled with a sqlcommand from my codebehind. This work very well, but when the user navigate through the listobjects' headers in the excel document, the excel process (excel.exe) sometimes it uses 50% - 90% cpu time for a minute aprox. I look for a codebehind event that produce this behavior, but nothing. So i think that is some process within excel.exe. I think that i need deactive some feature in excel, but no difference. someone have any idea for this. I appreciate some ideas Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 2
- RASK in Word 2007? Hello all, I'm wondering if the VSTO RASK (Requirements Authoring Starter Kit) can be deployed to Word 2007 Beyond customizing RibbonX to allow toggling of the RASK task pane, are there any other issues Thanks, Aidan Ryan Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 3
- Word's Autocorrect option in c# Hi All, I am developing a windows application. I suppose to implement word's autocorrection option in my application like accessing the entries, replacing, adding new word to list and deleting. Anybody have idea please send the reply. Thanks Suraj Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 4
- error while creating object for outlook Hi, I am trying to open addressbook from my C#.Net web application i am successful in opening addressbook through my code. my application is not giving any errors when i am running on my machine. but when i hosted my application in windows server 2003 and trying to access that same applications from other machines it is throughing an error at.. Outlook.Application oApp = new Outlook.Application(); The same error is coming when i hosted my application is my local m/c IIS also error description is like .. Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80080005. Thanks and Regards, Gnana Prakash Bodireddy. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 5
- Office 2003 Standard to professional upgrade Hello Our solution is composed of Outlook addin and Document level addin for Word. Office 2003 Professional is a prerequisite installation in our case since our addin is build using VSTO and .NET 2.0 (C#). One client of ours has Office 2003 Standard installed and would like to upgrade to Office 2003 PRO to start using our solution. We want to avoind unistall and reinstall of Office and install only the necessary componennts required by VSTO solutions. Which Office Components will we need to install is it just the .NET programability support is there anything else in PRO that needs to be installed Thanks Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 6
- Excel says "Document Not Saved". How to solve? Good day, all. I've found the following issue (step by step): Create a new Excel Template based on VSTO in Visual Studio Remove two of three sheets from the template's workbook that VS has just generated, so your template will consist of the only one page. Save the template and project. Run VSTO template Try to add a new sheet using template created in (2). Now, drag Sheet1 and drop it before Sheet2 (which was just added) Try to save document. Get a "Document not saved" message Excel just says "Document not saved" without any explanation and events. But! If you saved a document before (6), i.e. before sheets swapping, then Excel will save a document without any troubles. Moreover, if your template will consist of more then one page, the error will not occur. Does anyone has a clue about described behavior The another question from this area: If I'll add a new sheet, after it remove "primary" sheet (Sheet1, this is the only one sheet in template), and then save my document, so Excel will not load document correctly: it will ignore VSTO with an error. Thaks in forward, /Dmitriy Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 7
- Application.OnKey I want to disable short-cut "ctrl+s" in excel.. I use: Application.OnKey("^s", ""); But I want to activate again this chort cut. Application.OnKey have 2 parameters, string key and object procedure.. For reactivate short cut must second parameter to be omissed. Parameter is optional but in C# not exist overload of this method and must specified both parameters. I try with Application.OnKey("^s", null) but not working. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 8
- Adding Panel or UserControl to document host item I don't see Panel in the toolbox when customizing a host document (Excle Sheet). Is there a way to add my own panel and/or a User Control to the host document If I can add listboxes, textboxes, buttons, etc. why not allow to add a Panel as well. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 9
- Problem installing VSTO 2005 SE add-in for Word 2003 Hi! After solving a minor problem regaring installation parameters for my add-in last week, the installation succeded today. Now a different problem appeared. And I've seen that is a frequently visited topic in this forum, but none of the other threads have helped me so far. I'm developing a Word 2003 add-in with VSTO 2005 SE and everything is going great as long as I'm running a debug, but as soon as I install the add-in on my development machine it will not load when I start up Word. I've strictly followed the latest walkthroughs on deploying VSTO2005 SE add-ins, so theoretically it should work by now, but NO. For information about my development setup, read the first post on this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1858246&SiteID=1 Some help would be greatly appreciated. //Herman Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 10
- Applying Office Ribbon Style in your application. i have read that you can apply MSoffice 2007 style in your application as micorosoft has opened its R&D... what if i want to start doing that....... can i apply that style in vb.net applicatoins if so.. .any quick starters guide... Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 11
- Outlook: MAPI fields versus User Properties Hi, I want to improve an outlook addin which is using mapi fields (a lot) and this is generating abnormal behaviors in outlook, so now I'm in doubt to quit all use of mapi fields fo User Properties but I need some recomendatios or comments about using "mapi fields vs user properties" (or viceversa). Thanks, Mauricio. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 12
- MS WORD table border style hi, i have created word documents from my applicaiton(c#) but i couldn't set the table borders style to none. Can anybody help me about my problem thanks utku selamoglu Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 13
- [HELP!] COM Exception E_FAIL Adding Controls to ActionsPane Hi, I've built a document customization for Word 2003 using VSTO 2005 and it worked fine on my machine However on some other machines, my users report the error that occurs when the customization starts and the first control is added onto the ActionsPane. Below is the error description. Somewhere in forums I read that the error used to occur on machines without SP2 for Office 2003 and they recommended to workaround it by making the ActionsPane.Controls.Add(control) the very first operation in ThisDocument_Startup. It did work for the old installations, however I have found that with the Office build versions later than SP2 (such as 11.0.8106, 11.0.8125) people sometimes report the same bug, despite the workaround. Surprisingly, when I turned the workaround off for the newer builds, the bug disappeared again, but it worked only partially (e.g. worked for 8125, but didn't work for 8106). I hate to become dependent on user's build version of Word and I don't feel confident I will guarantee that the bug will not occur on other, yet untried machines and versions. THIS IS AN URGENT POST-DISTRIBUTION ISSUE. PLEASE HELP! Versions: ============================== Word: 11.0.8125 (SP2) .NET Framework: 2.0.50727.42 OS: Microsoft Windows NT 5.1.2600 Service Pack 2 Exception: ============================== Type: System.Runtime.InteropServices.COMException Message: Error HRESULT E_FAIL has been returned from a call to a COM component. Stack Trace: ============================== Class: Microsoft.Office.Tools.IActionsPaneSite Method: Void SetClient(System.Object) ------------------------------ Class: Microsoft.Office.Tools.ActionsPaneInternal Method: Void HookupSmartPane() ------------------------------ Class: Microsoft.Office.Tools.DockableControlCollection Method: Void Add(System.Windows.Forms.Control) ------------------------------ Class: StoryboarderPro.ThisDocument Method: Void InitializeCustomization() ------------------------------ Class: StoryboarderPro.ThisDocument Method: Void ThisDocument_Startup(System.Object, System.EventArgs) ------------------------------ Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 14
- Selection.Move infinite loop on Word 2007 document I am writing a Word 2007 add-in with VSTO SE. A button in my custom task pane moves the Selection through a document in steps of one paragraph. The code is shown below. It hangs midway through the document in an infinite loop. The document I am testing is a Microsoft financial document at http://www.microsoft.com/msft/download/FY06/MSFT_3Q2006_10Q.doc . Is this a bug It does the same thing if I save the document as a .docx file. The problem is the selection keeps moving in a circle in this table (from Page 20 of the document). Three months ended March 31, Percentage Change Nine months ended March 31, Percentage Change (In millions, except percentages) 2006 2005 2006 2005 Revenue .................................................. $ 10,900 $ 9,620 13% $ 32,478 $ 29,627 10% Operating income .................................. $ 3,888 $ 3,329 17% $ 12,591 $ 11,572 9% It loops the Selection in the following sequence forever: Percentage Change Nine months ended March 31, Percentage Change 2006 2005 (Repeats back to step 1) Here is my code: private void button1_Click( object sender, EventArgs e) { Word. Application app = Globals .ThisAddIn.Application; object objTrue = true ; object moveUnits = Word. WdUnits .wdParagraph; object moveCount = 1; int count = 0; Word. Paragraph p2 = app.ActiveDocument.Paragraphs.First; app.Selection.SetRange(p2.Range.Start, p2.Range.End); while (app.Selection.Move( ref moveUnits, ref moveCount) > 0) { count++; textBox1.Text = count.ToString(); textBox1.Refresh(); app.ActiveWindow.ScrollIntoView(app.Selection.Range, ref objTrue); } } Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 15
- There is no designer for the class Microsoft.Office.Tools.Word.Document I've never used VSTOR before and I've taken over a C# project that provides the code behind a Word template. When I try and view the .cs file behind the Word template in Design view, I get the following error: There is no designer for the class Microsoft.Office.Tools.Word.Document at System.ComponentModel.Design.DesignerHost.AddToContainerPostProcess(IComponent component, String name, IContainer containerToAddTo) at System.ComponentModel.Design.DesignerHost.Add(IComponent component, String name) at System.ComponentModel.Design.DesignerHost.System.ComponentModel.Design.IDesignerHost.CreateComponent(Type componentType, String name) at System.ComponentModel.Design.Serialization.DesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer) at System.ComponentModel.Design.Serialization.DesignerSerializationManager.System.ComponentModel.Design.Serialization.IDesignerSerializationManager.CreateInstance(Type type, ICollection arguments, String name, Boolean addToContainer) at System.ComponentModel.Design.Serialization.TypeCodeDomSerializer.Deserialize(IDesignerSerializationManager manager, CodeTypeDeclaration declaration) at System.ComponentModel.Design.Serialization.CodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager manager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.PerformLoad(IDesignerSerializationManager serializationManager) at Microsoft.VisualStudio.Design.Serialization.CodeDom.VSCodeDomDesignerLoader.DeferredLoadHandler.Microsoft.VisualStudio.TextManager.Interop.IVsTextBufferDataEvents.OnLoadCompleted(Int32 fReload) The project was created in Visual Studio 2003 and I am using VS 2005; I had to modify the .csproj file associated with the project to get it to open at all, I'm wondering if maybe that is the source of the problem I apologize if this is better suited to one of the other forums, please move it if appropriate. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 16
- Grief with ContentControlOnExitEventHandler Hi My code turns an event handler for this on and off, with public Microsoft.Office.Interop.Word.Document myDoc = Globals.ThisAddIn.Application.ActiveDocument; myDoc.ContentControlOnExit += new Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler(ContentControl_Exit); and myDoc.ContentControlOnExit -= new Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler(ContentControl_Exit); I have found that if I call myDoc.ContentControlOnExit += new Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler(ContentControl_Exit); n times (without calling -=), then the method void ContentControl_Exit(Word.ContentControl cc, ref bool InUndoRedo) will be invoked n times. Is this expected behaviour So I'm trying to ensure I only ever do += (without a corresponding -=) once. (Can C# tell me how many += I have in effect at any given time ) I'm trying to enforce either 1 or 0 by MyContentControlOnExit += new Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler(ContentControl_Exit); MyContentControlOnExit -= new Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler(ContentControl_Exit); private Boolean CcOnExitRegistered = false; public event Microsoft.Office.Interop.Word.DocumentEvents2_ContentControlOnExitEventHandler MyContentControlOnExit { add { Trace.WriteLine("In MyContentControlOnExit"); if (!CcOnExitRegistered) { myDoc.ContentControlOnExit += value; CcOnExitRegistered = true; } else { Trace.WriteLine("CcOnExitRegistered already .. ignoring"); } } remove { CcOnExitRegistered = false; myDoc.ContentControlOnExit -= value; } } Is that the recommended approach Finally, as a sanity check, I'm assuming that setting the above up in a Custom Task Pane means that it will only fire/handle in the document window that custom task pane is associated with, and not in the course of computing a .Compare or working in any new document the code in the Custom Task Pane (especially, ContentControl_Exit) may also create Word.Document remoteContent = new Microsoft.Office.Interop.Word.Document(); thanks very much! Jason Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 1
- Next
- 1
- A lot of pain with Word automation I'm having a lot of difficulty trying to do simple things with Word 12.0 Object Library. 1) When I try to create a new document... Microsoft.Office.Interop.Word.ApplicationClass oWordApp = new Microsoft.Office.Interop.Word.ApplicationClass(); Microsoft.Office.Interop.Word.Document oDoc = oWordApp.Documents.Add(ref missing, ref missing, ref missing, ref missing); Documents.Add returns null, and Documents.Count is still 0. 2) When I try to open an existing document.... oDoc = oWordApp.Documents.Open(ref fileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); it hangs at this statement and I have to stop it (I waited like 15 minutes). Can anyone help Please!! And thank you. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 2
- OleDbPermission error accessing assembly I have just installed the .Net Framework security update and started getting the following error when testing on my development PC: Request for the permission of type 'System.Data.OleDb.OleDbPermission, System.Data, Version=2.0.0.0, Cluture= neutral, PublicKeyToken=... ' failed. I am receiving the error in a VSTO Add-in for Word 2007 - this add-in accesses another VB.net assembly that uses oledb to lookup information in an Access db. Why would this suddenly appear following the yesterday's security update I am thinking I must need to set some OleDB permission parameters or machine-level security policy in Caspol.exe (or both). Could someone point me in the right direction Thanks. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 3
- VSTO C# Add-In Excel In-Place Activation Hi, The situation: - VSTO add-in for Excel - a workbook is edited in-place (Wordpad or Word) Problem: - wiring any events like Application_WorkbookActivate in the startup makes Excel hang; the shutdown or Application_WorkbookOpen events are not triggered; killing Excel and starting it again, it offers to recover the in-place edited file, meaning the OLE document was not correctly closed. - if no events are wirred Excel stops correctly (when WordPad or Word document is closed) Any idea Thanks! Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 4
- Ribbon menu and Toggle buttons Hello. I created group with 3 toggle buttons: < group id ="SData" label ="S Data" > < toggleButton id ="SDataAssignmnets" size ="large" label ="Assignments" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="Folders 32 n p.png" /> < toggleButton id ="SDataCustomers" size ="large" label ="Customers" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="File and Folder 2 32 n p.png" /> < toggleButton id ="SDataContacts" size ="large" label ="Contacts" screentip ="Show/hide external data Task Pane" onAction ="OnSDataButton" image ="Contact 32 h p.png" /> </ group > I want to use they like radiobuttons (only one button can be pressed simultaneously). How can I do that Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 5
- Override the VISIO menu Hello, I want to overload the VISIO File>Open menu so that i can show my custom open dialog when user click on it. Please let me know how i can implement it in C# Thanks Sunil Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 6
- How To Add a new ActionsPane in Powerpoint 2003? How To Add a new ActionsPane in Powerpoint 2003 Please send me some links or any code Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 7
- Excel sheet delete/rename/move/copy How do I handle following events in excel 2003 (with C#) sheet rename sheet delete sheet move sheet copy Also, is it possible to disable only a few options in sheet right click popup menu Protecting the workbook is not acceptable in my case. thanks... Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 8
- How I Can Add My Template to The Templates List of Word? I created a VSTO Word Template and I don't know how to add it to the word templates. I can run it by double-clicking on it, But I couldn't open it by "Select Template". Why How I can add it to the templates list of Word Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 9
- DataBinding in Excel2007 tables using VSTO SE When developing an application-level addin in VSTO SE for Excel 2007, is it possible to use the VSTO's Microsoft.Office.Tools.Excel.ListObject for databinding support I know how to create such ListObject from a Microsoft.Office.Tools.Excel.Worksheet, but I don't have a VSTO's Worksheet, only an Interop one. The objects I can use are the ListObject and Worksheet from the Microsoft.Office.Interop.Excel namespace, but they lack of data binding capabilities. Is there any way I can still use the Microsoft.Office.Tools.Excel.ListObject Thanks, Sole Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 10
- VSTO 2003 for Visual Studio 2003 One of my user use to work on Visual Studio 2003 and Microsoft Office 2000 in coordination to develop certiaon applications. He needs to have a compatible version of VSTO which can work with Visual Studio 2003 and Microsoft Office 2000. Is there any way I can download the VSTO 2003 compatible verison Thanks Amit Rao Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 11
- Action Panes and Excel Addins hello friend i am try to cerate Action pane for word document but am getting NullReference Exception and am choosing MSWord Addin Project and Am using MS office 2003 help me Using VS2005 and VSTO2e thanks in advance Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 12
- How to Create a new xls document from Excel addins (VSTO 2005 se / Excel 2003) How to Create a new xls document from Excel addins (VSTO 2005 se / Excel 2003) Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 13
- Use Outlook 2003 to send meeting request using c# Please help me I must send mail by c# and visual studio 2003 so i can't use VSTO for 2005 and also can' t use some tool that require liences. And more importance I must use COM by way access to Outlook 2003 to send mail. I got it but the big problem is ... security .. warning messages that i need access then mail will delivery +_+ it is big problem. So anyone here can help me. I research about outlook very much so i knew that .... create Add-in project and it ok ( because it will trusted with outlook). And another way is use VSTO for it but .. you know i can' t use visual studio 2005 . So how i can do it Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 14
- Fixed panel at left in a excel-worksheet Hi, I need a fixed panel in a worksheet, it has to scroll down or up with worksheet. I could not find a way to do that with VSTO. I use Excel 2007 and VSTO 2005 SE. I searched the forum but found nothing., What i want is something like that: http://stud4.tuwien.ac.at/~e0027385/excel-addin-panel.jpg the image was from an addin taken, so it must be possible but how Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 15
- Table Style in Excel 2007 Addin Hi, I am trying to create an excel addin for office 2007 using VS2005 & VSTOSE. I would like to create a table style on the startup. I tried calling the below procedure in ThisAddin_Startup(). Procedure runs but the style is not available. Can anyone help me on this. Public Sub TableStyles() Dim Thiswkbk As Excel.Workbook Thiswkbk = Globals.ThisAddIn.Application.ActiveWorkbook Thiswkbk.TableStyles.Add( "MyTableStyle" ) Thiswkbk.TableStyles( "MyTableStyle" ).TableStyleElements(Excel.XlTableStyleElementType.xlWholeTable) .Font _ .Color = RGB(51, 90, 143) With Thiswkbk.TableStyles( "MyTableStyle" ).TableStyleElements(Excel.XlTableStyleElementType.xlWholeTable).Borders(Excel.XlBordersIndex.xlEdgeBottom) .Color = RGB(51, 90, 143) .Weight = 2 .LineStyle = 1 End With With Thiswkbk.TableStyles( "MyTableStyle" ).TableStyleElements(Excel.XlTableStyleElementType.xlHeaderRow).Borders(Excel.XlBordersIndex.xlEdgeBottom) .Color = RGB(51, 90, 143) .TintAndShade = 0 .Weight = 2 .LineStyle = 1 End With End Sub Thanks, Mohan Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 16
- How to Set Default Form for Outlook Folder through C# Hi Frenz, I have been stuck with a very worst problem, almost search entire web but did'nt get any solution. My query is how do you set a default form (I have created that form) for an outlook folder through C#. I have been able to publish my form successfully through the code, however i can't set it default through the code so that whenever i create a new contact item in that folder it should use the form that i have created. I'm using Outlook 2003 & Visual Studio .Net 2003 with .Net 1.1 framework. I know how to set the form as default form for th folder manually but not through C#. If anyone knows the solution for the same request you to pls help me. Thanks in advance. Tag: Visual Studio Tools for Office How to get the range string of a worksheet.range object Office
- 1
- Previous
Michael Zh.
We all know that we can get a range object by using: get_range("A1:B1"), but if I have a range object, how can I get its address string --> "A1:B1"
I wants to create a chart and give its source value as "A1:B1,D1:F1,G1:H1", so I need to get the string of range address.
Thanks
I wants to create a chart and give its source value as "A1:B1,D1:F1,G1:H1", so I need to get the string of range address.
Thanks
Re: Visual Studio Tools for Office How to get the range string of a worksheet.range object
Asim Patnaik
Hi,
From a given range, you can get the address from the get_Address method:
Code Snippet
string strAddress = range.get_Address(System.Reflection.Missing.Value);
This may return strings in different format depending upon the way the range is selected i.e.
1. If it is a series of consecutive cells, then the string value would be like $A$1
C$1
2. If the selected cells are scattered, then the string value would be like $A$4,$B$6 or $A$1C$1,$M$1N$1
3. If only one cell is selected, then the string would be like $A$1
Hope this is of help
Btw, currently I am using Excel 2000.
Regards,
Asim.
Re: Visual Studio Tools for Office How to get the range string of a worksheet.range object
Asim Patnaik
Please replace the smiley with : and $ signs.
Regards,
Asim.