Get XPath in OpenXML VSTO2005SE

Visual Studio Tools for Office

Windows Tech ‹ Office
- Archive
  - VFP
  - Game
  - Smart Device
  - Dotnet
  - VC++
  - VB
  - ISV
  - Visual C#
  - SharePoint
  - Visual Studio
  - VS Express
  - Windows Vista
  - IE
  - Windows Live
  - Windows Forms
  - Office
  - VS 2008
  - Architecture
  - SQL Server

- Previous
  - 1
    - Outlook Contact Integration. I am working on a application that will need to view contacts from Outlook. The user would like to be able to create and delete contact from the custom application so that they don't have to switch back from app to app. I am not familiar with the Outlook API and I don't know if VSTO is required to do this. Thanks for your help Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 2
    - AppCheck.exe fails to find Office 2003 installed I have an outlook addin that I have created using the VSTO. It works on my machine but when I try and install it on anoher machine (I've only tried the one) for testing it fails saying it can't find a compatable version of Excel. Looking at the installation log (see below) it seems that it only mentions Excel as it's the first list and in fact it can't find Outlook or Word either. Office 2003 is installed on the machine and I wasn't aware of any other specific requirements. Is there something I'm missing, doing wrong or is there a known issue that I haven't found yet Versions: Excel 2003 (11.6560.6568) SP2 Outlook 2003 (11.6568.6568) SP2 Word 2003 (11.6568.6568) SP2 part of MS Office Std Ed Message: Prerequisite check for system component Microsoft Office 2003 Primary Interop Assemblies failed with the following error message: "Microsoft Office Excel 2003 is not installed on this computer. Install a version of Microsoft Office Excel 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System and then run Setup again." See the setup log file located at 'C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\install.log' for more information. Install.log: The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.2 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\dotnetfx\dotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer' Read string value '7.0.5730.11' Setting value '7.0.5730.11 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 7.0.5730.11 {string} Running checks for command 'dotnetfx\instmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass' Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'dotnetfx\dotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Office 2003 Primary Interop Assemblies', phase BuildList Running external check with command line "C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\Office2003PIA\AppCheck.exe" /excel Process exited with code 259 Setting value '259 {int}' for property 'SupportedExcelVersionInstalled' Running external check with command line "C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\Office2003PIA\AppCheck.exe" /word Process exited with code 259 Setting value '259 {int}' for property 'SupportedWordVersionInstalled' Running external check with command line "C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\Office2003PIA\AppCheck.exe" /outlook Process exited with code 259 Setting value '259 {int}' for property 'SupportedOutlookVersionInstalled' Running external check with command line "C:\DOCUME~1\xxx\LOCALS~1\Temp\VSDA.tmp\Office2003PIA\PIACheck.exe" {A1FE0698-609D-400F-BF10-F52238DD6475} {1C8772BD-6E6F-4C9D-8FF8-B5EA072F86EF} {14D3E42A-A318-4D77-9895-A7EE585EFC3B} {53C65973-D89D-4EA0-8567-8788C14E0A02} Process exited with code 1607 Setting value '1607 {int}' for property 'PIAsRegistered' The following properties have been set for package 'Microsoft Office 2003 Primary Interop Assemblies': Property: [PIAsRegistered] = 1607 {int} Property: [SupportedExcelVersionInstalled] = 259 {int} Property: [SupportedOutlookVersionInstalled] = 259 {int} Property: [SupportedWordVersionInstalled] = 259 {int} Running checks for command 'Office2003PIA\O2003PIA.msi' Result of running operator 'ValueNotEqualTo' on property 'SupportedExcelVersionInstalled' and value '0': true Result of checks for command 'Office2003PIA\O2003PIA.msi' is 'Fail' 'Microsoft Office 2003 Primary Interop Assemblies' RunCheck result: Fail A prerequisite failed for Package "Microsoft Office 2003 Primary Interop Assemblies" Package failed with message "Microsoft Office Excel 2003 is not installed on this computer. Install a version of Microsoft Office Excel 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System and then run Setup again." Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 3
    - bind listbox to namedrange Mohit, It would be highly appreciated if You could provide us with a minor case Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 4
    - cannot see office templates I install vsto2005se and also install full version office 2003 and visual studio 2005. I want to create new project of type office template. But i cannot see any templates under office, i can only see office add-ins. Please mail me to kdinuk@yahoo.com Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 5
    - Getting default Mso labels Hi, I'm sure that during developing with VSTO 2005 SE I saw somewhere functions like "getMsoLabel" and "getMsoImage"...but I can't find them anywhere now... anybody knows about them I need to get string of built-in control / group / tab... in order to handle localized versions of office... and I hope a little this functionc could do that work.. Thanks Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 6
    - Using the Server Capabilities in Microsoft Visual Studio 2005 Tools for Office to Build a Benefits Registration System Hi, I've installed the sample OfficeVSTOBenefitsRegistration.msi from http://msdn2.microsoft.com/en-us/library/aa537190(office.11).aspx It runs well when I use the default ports (2420 for the C# and 2288 for Vb.NET) but I get this error when I configure the web application to use any other ports: I've already got a fix from MS http://support.microsoft.com/kb/915781 but I still get this error, I'm running out of options any ideas Here is the error I keep getting: Failed to update customization from the specified deployment manifest. ************** Exception Text ************** Microsoft.VisualStudio.Tools.Applications.Runtime.UpdateFailedException: Failed to update customization from the specified deployment manifest. ---> System.Net.WebException: The request was aborted: The request cache-only policy does not allow a network request and the response is not found in cache. at System.Net.WebClient.DownloadDataInternal(Uri address, WebRequest& request) at System.Net.WebClient.DownloadData(Uri address) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.DownloadManifest(WebClient webClient, Uri uri, Boolean fallBackToCache) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.LoadAndUpdateApplicationManifest(IAppInfo appInfo, Uri documentDirectoryUri, Uri& newAppManifestPath, Boolean& appManifestDirty) --- End of inner exception stack trace --- at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.LoadAndUpdateApplicationManifest(IAppInfo appInfo, Uri documentDirectoryUri, Uri& newAppManifestPath, Boolean& appManifestDirty) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.CreateCustomizationDomainInternal(Uri uriFullDocumentDirectory, Uri uriFullDocFilePath, String documentName, IHostServiceProvider hostCallback, IAddinSecurityManager secman, AppManifest& applicationManifest, Boolean& manifestDirty, IAppInfo& appInfo) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManagerInternal.CreateCustomizationDomain(String applicationDomainPath, String documentName, IHostServiceProvider hostCallback, IExecuteCustomization& executor) at Microsoft.VisualStudio.Tools.Applications.Runtime.AppDomainManager.CreateCustomizationDomain(String applicationDomainPath, String documentName, IHostServiceProvider hostCallback, IExecuteCustomization& executor) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Microsoft.VisualStudio.Tools.Applications.Runtime Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.816 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime/8.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- Microsoft.Office.Tools.Common Assembly Version: 8.0.0.0 Win32 Version: 8.0.50727.816 CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.Office.Tools.Common/8.0.0.0__b03f5f7f11d50a3a/Microsoft.Office.Tools.Common.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.42 (RTM.050727-4200) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 7
    - Office 2007 PIA - Office Primary Interop Assemblies - problem - not installing I'm a bit confused... You say "The Microsoft.Office.Interop.xxx DLLs are not installed anywhere. I have the whole of Office 2007 Ultimate installed and I am logged in as local admin, Windows 2003 Server Enterprise with SP2. The ' .NET Programmability Support ' Outlook option was select during the install of Office Using VS2005/VSTS I can only add the Microsoft.Office.Core reference, the required COM Outlook interop DLL is not present in the COM list or anywhere on the computer. I have office installed on C Drive and VSTS on D drive if that makes any difference Microsoft.Office.Interop.Outlook v.12 etc are visible in the GAC ....." If you find this Interop in the GAC, then the PIA is already installed on the machine. The things you see in the GAC should also be available in the COM tab of the Add Reference dialog box. The entry would look something like "Microsoft Outlook 12.0 Object Library" You're saying you do not see this in the dialog box, even though you see the entry in the GAC Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 8
    - Retrieve current document path Wow, thank you (both) for your time; that really helped! Again, I'm sorry for such beginner' questions but just "came" from unix and .net is sooooo different. But much better documented and supported! Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 9
    - Best practices for VSTO SE Addins Hi, I did use all the codes above on my environment. Why there is no Outlook.Folder property It seems that you are using Outlook2003, right OK, I will write some codes in Outlook 2003 and post later. Thanks Ji Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 10
    - How to get closing Inspector pointer? Hello Helmut, Again, your post was very precise and clear. I really appreciate it. This was very helpful to me. What I can say now is only that I hope that I could return a favor to you some time in the future. P.S. I see that you do addin development in C#. So I��m curious: Is development much easier using that programming language (guess client has to have .NET framework installed on his computer before installing addin), or maybe you are experienced in C# so you decided to do development of addin��s in C# too (I��ve been developing some addins for Office apps in C++ and it can be a bit pain sometimes) Thanks again! Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 11
    - Downloading XML Data in Access I have an access application that needs to download a set of XML files on a weekly basis. I then load this data into my application. The developers of the site i'm downloading the files from have provided a URL to which you post an ilogin and ipassword variable. You are then supposed to get a reply of OK or failed. After authentication, session should be created with Session Key ("XMLSessID") passed as a cookie... I would then need to go and Load and Save each of the XML pages, using this authenticated session. Without embedding an IE browser into the MS Access application, how could i do this Thanks! -Ben Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 12
    - Outlook Add-in Not Loaded. Runtime error try writing logs to check if the addin is actually loaded ! Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 13
    - Outlook Addin install problem for stand alone Outlook install Hi, I have created an Outlook 2003 Addin that runs fine but I am having trouble getting the install package to work under certain circumstances. Using the available walk-throughs that are available on MSDN I have created an install package that seems to work fine when installing on a PC with Office 2003 on it but fails if the PC only has a stand alone version of Outlook installed. When it fails it is telling me that it failed because Outlook is not installed. Note: The problem isn't with installing my program itself but rather in the Launch conditions section where it verifies that all the prerequisites are installed. Most of what I have used to generate the install package comes from: http://msdn2.microsoft.com/en-us/library/aa537173(office.11).aspx and http://msdn2.microsoft.com/en-us/library/aa537179(office.11).aspx (Sorry, I couldn't get the links to post for some reason.) I have modified the Bootstrap product.xml file for the Office2003PIA package so that it only looks for Outlook but the installer is saying it can't find Outlook so I don't think the problem is that it is looking for the other parts of Office. I'm sure it is something dumb that I am missing but everything seems to be setup ok and as best I can tell the component and product IDs are correct. I was just wondering if anyone else has seen anything similar if they ran across a PC that only had individual products installed instead of the actual Office suite. Thanks, Everything I have tested it on is running Windows XP SP2 and Outlook/Office with SP2. Here is the log file from the installer. The following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.1.2 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:\DOCUME~1\HENDER~1.FRA\LOCALS~1\Temp\VSD4.tmp\dotnetfx\dotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLM\Software\Microsoft\Internet Explorer' Read string value '6.0.2900.2180' Setting value '6.0.2900.2180 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 6.0.2900.2180 {string} Running checks for command 'dotnetfx\instmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'dotnetfx\instmsia.exe' is 'Bypass' Running checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'dotnetfx\WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'dotnetfx\dotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'dotnetfx\dotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Office 2003 Primary Interop Assemblies', phase BuildList Running external check with command line "C:\DOCUME~1\HENDER~1.FRA\LOCALS~1\Temp\VSD4.tmp\Office2003PIA\AppCheck.exe" /outlook Process exited with code 259 Setting value '259 {int}' for property 'SupportedOutlookVersionInstalled' Running external check with command line "C:\DOCUME~1\HENDER~1.FRA\LOCALS~1\Temp\VSD4.tmp\Office2003PIA\PIACheck.exe" {14D3E42A-A318-4D77-9895-A7EE585EFC3B} Process exited with code 1607 Setting value '1607 {int}' for property 'PIAsRegistered' The following properties have been set for package 'Microsoft Office 2003 Primary Interop Assemblies': Property: [PIAsRegistered] = 1607 {int} Property: [SupportedOutlookVersionInstalled] = 259 {int} Running checks for command 'Office2003PIA\O2003PIA.msi' Result of running operator 'ValueNotEqualTo' on property 'SupportedOutlookVersionInstalled' and value '0': true Result of checks for command 'Office2003PIA\O2003PIA.msi' is 'Fail' 'Microsoft Office 2003 Primary Interop Assemblies' RunCheck result: Fail A prerequisite failed for Package "Microsoft Office 2003 Primary Interop Assemblies" Package failed with message "Microsoft Office Outlook 2003 is not installed on this computer. Install a version of Microsoft Office Outlook 2003 that supports Microsoft Visual Studio 2005 Tools for the Microsoft Office System and then run Setup again." Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 14
    - Permitting Excel VSTO doc to run from anywhere on intranet Thanks for the response Ji. I'm aware of that deployment model and I'd rather not use it. The main factor for using that deployment model is number of users. There are only going to be 3 or 4 users of this application so managing updates to the app will be easy even with local installations. It seems in this case that deploying to a server location adds complexity that isn't necessary. To recap... I have an Excel template (XLT) and the automation DLLs installing to Program Files\CorpDir\AppDir. The user is not able to alter the installation directory. During installation I update the embedded application manifest to look for the automation DLL in %ProgramFiles%\CorpDir\AppDir. Using the environment variable allows the automation to be found regardless of where Program Files exists (like if it is not on the C drive). I update CAS according to the MS walkthrough on deploying a VSTO document locally. The sticking point is that last bullet. I'm not sure how to update CAS so that if the document is opened from a network location it is still allowed to run the automation. I want the automation to remain local but the document can be opened from a network location. If a user has the automation installed then it will run. If a user does not then they'll get that message stating the automation cannot be found but they can still use the document. This seems like it should be possible because the embedded application manifest should always point to the local automation whether or not it exists. Using the environment variable in the automation path should guarantee that it will be found if it exists. The confusing part is where does CAS consider the automation to be running from if the document is opened from a network location Only the document has moved, not the automation. The automation still exists in the local (Program Files) directory for which I'm granting permissions for it to run. Do I need to change how I grant permission for the automation to run Do I need to do something in CAS for document permissions Since I've only received 1 response to this and it didn't really answer my questions (no offense Ji) I'm assuming I won't get any answers so I may have to use server deployment. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 15
    - Properties Question I'm looking for a way to make my property browsable outside of the visual studio environment. For example, I have a property within my windows control called Interval. If I set the browsable attribute to true I can access the property through the properties window when I use the control in other projects. What I am trying to do is make the property visible in the InfoPath properties window. I have all the COM necessary to make the control workable in InfoPath I'm just not sure how to get this property visible at design time. Any help would be appreciated. TIA, Eric Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 16
    - Can ContentControls be bound to a collection of Nodes? I need to implement the following functionality in Word 2007: I have created a ContentControl in a Word document. Also I have a button on the Ribbon Control. When I click on the button, the ContentControl needs to be replaced by a Word Table. The data for table would come from database. Another functionality which is required is the ability to right click the content control and choose the columns to be displayed for the table using a context menu. So far I have seen content controls being bound to a single node using CustomXMLPart. However I haven't found anything which shows how to bind it to a collection of nodes. So I have 2 questions. 1. Can content controls be bound to a collection of nodes If not what is the best way of replacing a placeholder in Word with a table. 2. Can custom ContextMenus be attached to content controls Any sample code or pointer in the right direction will be very much appreciated. Thanks, Shirish Pulikkal Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
- Next
  - 1
    - Button text is cut off when using a winform from vsto Hi again, Do you mean when you click the button on the ribbon, winfrom in the extra assembly shows up, and the texts of buttons in it are cut off Where did you get the assembly You write it or get it from elsewhere. Can you code the assembly, the autosize property must be assigned to true, then the button will extend by the length of text. I have reproduced your scenario by following steps: I create a winform application using C# in VS 2005 I create a Outlook2007 Addin using C# in VS2005(VSTO SE) I add winform application as a reference into the Addin project, so we can use the winform. In the ThisAddIn_Startup, I add codes to show the winform(I have also tested it in a function which invoked by a button in ribbon) Code Snippet private void ThisAddIn_Startup(object sender, System.EventArgs e) { WindowsApplication1.Form1 myForm = new WindowsApplication1.Form1(); myForm.Show(); } Build the addin , the winform shows up, and everything seems ok. Text on the button is complete. If I have misunderstanded your issue, please feel free to let me know, so future discussion will be performed to solve your problem. Thanks Ji Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 2
    - VSTO installation issue with office 2007 after uninstall office 2003 Hi again. I uninstalled the office2003, and installed office 2007 professional, now when i tried to install VSTO2005 im receiving an error message asking for the office 2003 service pack 1 . What that means i need office2003 and 2007 installed on my machine Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 3
    - Question re the CRM Integration Add-In Sample For Outlook 2003 (2) I forgot to point out that the CRM sample itself includes a SQL synchronization component if you want to see how that's done. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 4
    - Show the savdialog after DocumentBeforeSave Well, in the main "question" dialog on your "SaveAs" button click event, you should have been able to do something like: void OnSaveAsButtonClick(object sender, EventArgs e) { SaveFileDialog sfd = new SaveFileDialog(); try { this.Visible = false; if (sfd.ShowDialog() == DialogResult.OK) { //TODO: call the Word SaveAS() method here //passing it the filename entered by the user //in the SaveAsDialog } } finally { sfd.Dispose(); this.Close(); } } The SaveFileDialog does not automatically handle saving the document or anything, it merely provides a UI from which the user can enter the filename they want to "Save as", you still have to manually code the rest of the logic ... Hope this helps. D. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 5
    - Word Add-in not available while opening documents I just have WordAddIn1.ThisAddIn in the left drop down list. Thanks Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 6
    - FV result is being different from Pure Math Calculation ? Could anyone please help me to rectify the following problem. Compounded ROI Term(Yrs) Term (Months) TotTerm Instalment Halfyearly 8% 6 0 =(6+(0/12)) 6 1000 (=8%/2) =6*2 =1000/2 2 0.04 12 =500 If I use Excel FV Function like this FV(0.04, 12, -500, 0, 1) The result becomes 7813.42 But if I calculate in the following way: 1000 6 =ROUND(1000*(1+(0.04))^(12),0) = 1601 1000 5 =ROUND(1000*(1+(0.04))^(10),0) = 1480 1000 4 =ROUND(1000*(1+(0.04))^(8),0) = 1369 1000 3 =ROUND(1000*(1+(0.04))^(6),0) = 1265 1000 2 =ROUND(1000*(1+(0.04))^(4),0) = 1170 1000 1 =ROUND(1000*(1+(0.04))^(2),0) = 1082 The result becomes 7967 The difference is being 153.58 I would like to know the correct Excel Function. Thanks in advance. Regards, Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 7
    - How to host Infopath forms in a custom Word task pane Could anyone point me in the right direction for this, please I know a custom task pane hosts a custom control, so how do I load an Infopath form into the control, or can a task pane host an Infopath form directly Thanks for any help! By they way, I know that Infopath forms can be made to show in the Document Information Panel. I need it in the task pane and I need to be able to handle it's events in the Word Add-In that loads the task pane, for example. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 8
    - ContentControlOnEnter Hi, I have problem : I create complex content control (from several content controls and other text and table elements then group all this components) then I hooking ContentControlOnEnter event . All good. But some times after editing text or clicking on other controls - event(ContentControlOnEnter ) not sended any more // some code object zero = 0; Range range = app.ActiveDocument.Range(ref zero, ref zero); Table table = app.ActiveDocument.Tables.Add(range, 2, 1, ref WordUtils.OBJ, ref WordUtils.OBJ); table.Borders.Enable = 1; table.Borders.OutsideColor = color; table.Borders.InsideColor = color; table.Rows[1].Range.HighlightColorIndex = WdColorIndex.wdGray25; app.Selection.TypeText(title); table.Rows[2].Height = 500; ContentControl control1 = app.ActiveDocument.ContentControls.Add(WdContentControlType.wdContentControlText, ref WordUtils.OBJ); WordUtils.MoveDown(app); ContentControl control2 = app.ActiveDocument.ContentControls.Add(WdContentControlType.wdContentControlBuildingBlockGallery, ref WordUtils.OBJ); ///////////////////////////////////////////////////////////////////// app.ActiveDocument.ContentControlOnEnter += new DocumentEvents2_ContentControlOnEnterEventHandler(ActiveDocument_ContentControlOnEnter); Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 9
    - 'Undo' problem Hi Kenneth OK, I merged that other message thread with this one so as to avoid confusion / duplication of effort. What is the label (caption) of the single item you see on the Undo stack Note that you may want to take this question to the Powerpoint newsgroup . There are people there who create Add-ins and will be more familiar with any idiosyncracies of how Powerpoint works in this regard. You won't find many specialists in that application here. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 10
    - How to deploy an Excel template (XLT) thats creates Excel (XLS) documents? Hi, I have an Excel 2003 solution (Code behind an Office document) on VSTO 2005, the solution have a MyExcel.xlt document. I wanna the XLT permit to create multiples XLS files for different projects, using the structure and logic of my XLT document. In the first ActionsPane control of my XLT file I have two options: 1. Create a new project: the user writes a name and the project "Save As" the document(for example, create a new "cars.xls" file). 2. Open a document: open and continues a file created by the Template (.XLT) (for example, open the "cars.xls" file) and work on its. I have created a "setup project" and a "custom setup project" to set the user's security policy, as seen on the "Chapter 20. Deployment", Section "Creating Setup Packages" of the book "Visual Studio Tools - Using Visual Basic 2005 with Excel, Word, Outlook, and Infopath". I install the generated setup in a custom folder "c:/MyProject" and it works OK, I copy the "MyExcel.xlt" template to other folders and work OK, but when I created a file XLS ("cars.xls") based on the template and I try to open it, I get an error: (I'm using a spanish version of the MS Office 2003, I don't know how the message appears on the english version, the message is about the document personalization on office is not available, because the personalization assembly cannot be loaded) --------------------------------------------------------- La personalizacion de documentos de Office no esta disponible No se pudo encontrar o cargar el ensamblado de personalizacion. Puede editar y guardar el documento. Pongase en contacto con el administrador o el autor de este documento para obtener ayuda. --------------------------------------------------------- Is an error on the logic I uses to created differents files based on a template What I need to do on the template or setup proyect Please, sorry my english. Thanks! Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 11
    - Adding a context menu item for a chart in Excel? Thank you for the code example, unfortunately I don't have Office 2003 (only 2007) so I tested with that and got the same results. Here's a screenshot: http://www.jhurliman.org/images/excel2007-nomenu.png You can see all the typical menu items for a chart showing up, but no custom "My Item". It seems like straightforward code, maybe you have to take a different approach in 2007 Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 12
    - MS Word Automation (2000, XP, 2003 & 2007) in C# ? Thanks for your help Cindy. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 13
    - Current Profile Name Brent, Other people have said a flat "no" for Outlook 2003, and as this is VSTO I don't think any earlier versions are supported, however the above VB code might work for you in older versions. Dino Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 14
    - Excel Events Hi BB, See if the following event can help You trap row deletion: Private Sub Application_SheetChange(ByVal Sh As Object, ByVal Target As Microsoft.Office.Interop.Excel.Range) Handles Application.SheetChange Dim sheet As Excel.Worksheet = Sh MessageBox.Show(sheet.Name & " " & Target.Row) End Sub Edit: Next time I will refresh the cache before postings. Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 15
    - Fixed panel at left in a excel-worksheet Think out of the box and be creative in building your solutions Which box Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office
  - 16
    - Add header to outgoing mail Hi all, I've seen this Post and I have no finnished sample for this. But you have my proof of concept code already that can read and write properties. You can do it also with redemption: see http://www.dimastr.com/redemption/ Dmitry has shown us the way to do it: tag = sItem.GetIDsFromNames("{00020386-0000-0000-C000-000000000046}", "x-test-header") tag = tag or &H1E ' the type is PT_STRING8 sItem.Fields(Tag) = "test value" I will try to create a sample C# snippet - but it takes a little time to hack this out. If I got it I will post it here - on my and on Sue's site. Greets, Helmut Tag: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE Office

laiseng

I'm currently developing an application on top of Office Word 2007 using VSTO 2005 SE

Since .docx documents is using OpenXML i would like to be able to get the XPath of the selected column or tables or any elements in the document itself.

so that later i could refer to this XPath and extract information of that particular path and do something about it by opening document.xml

It would be great if there is a way to get the XPath when i selected a cell in a table and it will give me the XPath of the XML after i've clicked on a button which does that..

Top

Re: Visual Studio Tools for Office Get XPath in OpenXML VSTO2005SE

Christin-MSFT

Have you tried looking at the Open XML information at http://openxmldeveloper.org/ It's a great site with tons of sample code. Let me know if that helps.

Top