Cache data in workbook created from addin

Visual Studio Tools for Office

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

- Previous
  - 1
    - Upgrade from Office 2003 Standard to 2003 Professional Oleg, If you've developed VSTO 2003 document-level customizations (e.g., Word), these will work in Office 2007; and in most cases, with minor changes. I developed a significant VSTO Word 2003 document-level customization, and have it running on both 2003 and 2007. My only real problems reside on the Tablet PC implementation, because of some specialized Toolbars I create ... but that's about it. Something else to consider, asking your clients to spend money on Office 2003 Prof. only for them to have to later purchase Office 2007, seems like an added expense that your clients shouldn't have to endure. Also, this is just an FYI: VSTO solutions for Office 2003 required Pro. but under Office 2007, any edition supports VSTO customizations (there is a post, somewhere in this forum, from a MS employee that discusses this very point). Good-luck. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 2
    - Problem with ThisAddIn_Shutdown and CommandBar in Outlook 2007 Hello Tad, The commandBar and VommandBarbutton variables should be declared within the class. Where do you have declared the variables Can you show us a codesnippet Greets, Helmut Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 3
    - Form opening up a word.dot VSTO And exactly what parts of the ThisDocument_Startup procedure do run Do yo usee the messages boxes What happens if you put the full path in for the template in the other Documents.Add statement Mostly, Word does want the full path for this method... Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 4
    - Save a word document objDoc.Save() It's also possible to specify saving as an argument of the Close and Quit methods - read the object model help. Since your questions have nothing to do with the VSTO technology - the topic of this forum - but are aimed at general Word automation, please ask new and follow-up questions in the office.developer.automation newsgroup . Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 5
    - Form Region display issue Hi Rafael, In my side, it works well. Text of button in Outlook Form Region appears exactly as I design them to be. Make sure you set the AutoSize property to 0(false). This property only appears in advanced property dialog. Thanks Ji Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 6
    - OutlookSpy and Control ID's Hi, You can use the following codes to list the CommandBar and CommandBarControls’s ID, Name property, via Outlook Add In or Outlook automation. Just loop through the collection and write it out to a text file. Code Block //Create a new txt file to record controls' list StreamWriter sw = System.IO. File .CreateText( @"C:\Outlook Insepctor Command Bar Control List.txt" ); //loop through Outlook ActiveInspector CommandBars to get all CommandBars foreach (Office. CommandBar cb in app.ActiveInspector().CommandBars) { sw.WriteLine(cb.Name); //loop through each CommandBar's Controls collection to get all controls foreach (Office. CommandBarControl cbc in cb.Controls) { sw.WriteLine( "\t" + cbc.Caption + "\t" + cbc.Id.ToString()); } } sw.Close(); Code Block //Create a new txt file to record controls' list StreamWriter sw = System.IO. File .CreateText( @"C:\Outlook Explorer Command Bar Control List.txt" ); //loop through Outlook ActiveExplorer CommandBars to get all CommandBars foreach (Office. CommandBar cb in app.ActiveExplorer().CommandBars) { sw.WriteLine(cb.Name); //loop through each CommandBar's Controls collection to get all controls foreach (Office. CommandBarControl cbc in cb.Controls) { sw.WriteLine( "\t" + cbc.Caption + "\t" + cbc.Id.ToString()); } } sw.Close(); Hope it helps! Thanks Ji Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 7
    - Visual Studio Tools for Office VSTO Word Since VSTO document-level solutions are document-specific, it's not possible to have more than one document as part of a single solution. It is possible to create a Word template, from which multiple documents can be created by the user, all linking back to the managed code that's part of the Template's VSTO project. It's also possible to use the ServerDocument feature of VSTO to link an existing VSTO DLL with a "non-VSTO" document. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 8
    - Registry entries for all users (Outlook add-in) I think Misha may cover that in his post at http://blogs.msdn.com/mshneer/archive/2007/09/04/deploying-your-vsto-add-in-to-all-users-part-i.aspx or in the comments. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 9
    - Method to refresh/update Word toolbar state Have you tried the ScreenRefresh method of the Application object Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 10
    - How to Add custom information in an appointment item using VSTO SE Outlook 2003 Addin ? Hello Kulvinder, for this scenario I would use an XML string stored into the milage field. (or a custom defined field). With .Net doing XML is easy. The drawback is that you can't display the data in a standard Outlook View. Hope this helps, greets, Helmut Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 11
    - Copying RTF into word and from word to a richtext box using c# It is not possible to directly transfer the content of a RichText control into a Word document. Word requires a converter to display RTF as Word text, and its built-in converters only trigger on pasting from the Clipboard or inserting from an external file. The same would hold true for transferring formatted text in Word to an RTF control: either save it in RTF format to a file and stream that into the control. OR copy to the clipboard and paste into the control. Other than that, if we're discussing Word 2003, you could build a converter (transform) into your project that turns the RTF into WordProcessingML. It is possible to insert Word's native XML directly into a Word document. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 12
    - connecting excel file to C++ program Hi, This isn't really the correct forum for your question. This forum deals with a product that allows you to automate Office using managed code (either C# or VB.NET). Here is an article however that you might find useful to get started: http://support.microsoft.com/kb/216686 / Also, check out: http://support.microsoft.com/kb/196776/ Best of luck with your studies! Sincerely, Steve Hansen Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 13
    - Which "Event Handler-adding" code is more appropriate for my application add-in? Hi Mike Mmmm. As to why your code isn't working, the object variable you declare for your button - uiConvert - isn't used anywhere in your code. If nothing is assigned to the object variable, then any buttons you're creating won't pick up any event handlers. The VB equivalent of Approach 2 is to use the AddHandler (and RemoveHandler) methods. They're described in this KB article HOW TO: Handle Events for Excel by Using Visual Basic .NET http://support.microsoft.com/kb/302814/en-us C# has no equivalent to Approach 1. Approach 1 is "simpler", but does not allow as fine a control. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 14
    - COM Exception Error Which version of Office is installed on the end-user's machine At a guess, I'd say it's not Office 2003 PROFESSIONAL, which is the only one that provides the XML resources the error message is going on about at the top. If that's not it, then you need to tell us what your VSTO 2005 SE Add-in is doing on startup. And what roll does a document template play Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 15
    - VSTO SE 2005 Runtime Setup for Windows VIsta Hi Kulvinder, An update to this runtime is being released for Windows Vista and will be available soon for download. Thanks Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 16
    - Publish deployment issue Ok, so I think I've got a better idea of what the issue is. One major problem I ran into with the publish feature is that it always requires an active internet connection for the addin's to load (they oddly load from the network share and not the local drive). This was a major issue as any time the net connection went down or the user was working disconnected (laptop), the addin-load would fail and they would be disabled. In order to get around this I wrote my own auto update modification that restarts the office application in question, copies the relevant files from the publish location and updates the versions in the local manifest. This works great, up until now where I realize what the issue is that I'm having. All of my office addins use project references to shared assemblies to reduce repetitive code (I wanted to have common features available across the office suite). Whenever I publish one project, this updates the versions of those assemblies which subsequently breaks the addins for those apps that wern't updated. Is there any way to disable the versioning or get around this issue so that my add-ins won't break Because the loading of addins is embedded in VSTO code, it's been a huge hurdle to write around the numerous issues I encountered and this one looks like a biggie. Thanks, Denis Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
- Next
  - 1
    - A question about office clipboard Your question is not really related to this forums subject and you are most likely better served by posting similar questions in forums/newsgroups related to Office Development or if I understand your question correctly in a group on Shell programming. It is helpful to remember that this forum is mainly for issues that directly pertain to the Visual Studio Tools for Office tools per se. To get you started, for general questions regarding the PIAs, you can post to the Office automation newsgroup: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.officedev&lang=en&cr=US Depending on having events triggered my guess would be that you should scan for the 'focus' window in order to determine the target destination of the paste.... -= Maarten =- Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 2
    - how to implement "in-Ribbon" Gallery ? Hi there, In-Ribbon galleries are not suppoted in Ribbon XML. It is a commonly requested feature but not something that is available in the current extensibility model. Thanks, Rachel Schaw (MSFT) Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 3
    - Excel Edit Delete Disabled If the user opens up a non VSTO document is Delete also disabled or only on the VSTO target document Also is the control on the page or the action pane Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 4
    - Publishing VSTO 2005 SE addin to a network location Hello Rakesh, I can be wrong - but as I know currently there is no click once support for VSTO Application AddIns. But to answer the questions for Registry and Deployment. You can use Active Directory and an OU (Organizational Unit) to deploy registry settings and software to users. You can use a login script to copy files to the clients when the clients are startet or when the users log on to the domain. I'm usualy would create a Setup-Application with the SetSecurity project and deploy this msi by Active-Directory or SMS Server to the Clients. From there you can also push a new Version. The Security and the Registry is changed by the setup project. Hope this helps, greets, Helmut Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 5
    - WordApp.Selection.Range.set_Style throws exception Hi, It results from that word cannot find the specified element. I record a macro in the Word and find that the string stands for Heading 2 is “Heading 2”, not “Heading2”. There should be a space between Heading and 2. Codes below works: Code Block object styleHeading2; object styleHeading3; styleHeading2 = "Heading 2" ; styleHeading3 = "Heading 3" ; app.Selection.Range.set_Style( ref styleHeading2); Thanks Ji Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 6
    - Excel Solver macro from VB.NET The best place to get an answer to your macro question is in the Excel newsgroup. Please post your question here: http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US Thanks! Mike Hernandez Community Program Manager VSTO Team Off-topic posts will be deleted Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 7
    - VSTO Addin crashing outlook on select machines Found out the problem was the select machines did not have the Microsoft Office PIA's installed. I ran the install for the assemblies and the addin worked. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 8
    - Interact with MS Access using VB Hi RMS81, Access is not a platform currently supported by VSTO. I would suggest asking the question in the one of the access discussion lists here: http://msdn.microsoft.com/newsgroups/topic.aspx url=/msdn-files/028/201/016/topic.xml Now, a quick search in MSDN reveals that Access provides the Application.CompactRepair method that might fit your needs, just recall that you cannot repair a database that is currently open. http://msdn2.microsoft.com/en-us/library/aa221162(office.11).aspx Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 9
    - execute a vsto project on a remote machine I've installed the PIA from here : http://www.microsoft.com/downloads/details.aspx FamilyID=59DAEBAA-BED4-4282-A28C-B864D8BFA513&displaylang=en and it works fine. :-) Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 10
    - Highlighting the active field in the task pane Is this a document-level customization, or an Add-in Can you be more specific about what you mean by "highlight" The controls in a task pane are usually WinForms controls, and are most commonly part of a UserControl "container". Have you defnied a UserControl for your task pane All the commands normally available to you for working with controls in WinForms are therefore available for the controls in a task pane. Which WinForms property (or properties) would you want to use for the "highlight" Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 11
    - What about Macs? Hi Oleg, Sorry, both the .Net Development Platform and Visual Studio Tools For Office are Windows only. Sincerely, Geoff Darst Microsoft VSTO Team Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 12
    - building outlook toolbar in contacts It's done by using the Inspector window instead of Explorer. See http://www.outlookcode.com/codedetail.aspx id=797 for a code sample. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 13
    - Excel Automation: How to use an external link as an argument in a user-defined function? Hi, See if the following blogpost can get You started: http://www.dailydoseofexcel.com/archives/2004/12/01/indirect-and-closed-workbooks/ No matter what, it will be a slow performance and therefore ADO.NET or better up classic ADO will not look so clumsy after all. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 14
    - Docx to Clean HTML To get cleaner HTML you may have to resort to transforming the DocX file yourself. There are several articles on the web that describe the process (a link to the first one I came across is below). How complicated that process would be depends on how much of Word's native formatting you need to preserve during the conversion. http://www.quepublishing.com/articles/article.asp p=691502 You may get a better answer in an Office- or Word-specific forum, as VSTO does not provide any additional capabilities in this area. -Phil Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 15
    - Fuzzy text in a label control Hi Art, Does it refer to design time or during runtime If it the first case then I would guess it's per default. I got the same scenario during design time. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office
  - 16
    - Microsoft.Office.Tools.Excel Items and controls in Excel 2007 with VSTO SE Hi spano, I want to migrate a document-customization project for Excel 2003 to Excel 2007 but I see there is no document-customization project template in VSTO SE. Only the application level addin template is available. That's correct however You can use a workbook level solution created with VSTO 2005 & Excel 2003 with Excel 2007. By using this addin, I get to the Excel Application object...but how can I use the ListObject data binding, or the NamedRange objects Is it possible Or I have to access the cells using the interop objects Since none of the objects (ListObject and NamedRange) are persisted You need to access the cells through the interop objects. But it's possible to create a ListObject, populate it with data and then disconnect the ListObject from the range (see http://xldennis.wordpress.com/2007/05/08/csv-files-listobject-controls-and-vsto/ ). This approach speeds up things when retrieving data from databases and to populate worksheets. Besides, there is a way I can check the active workbook is based on a particular Excel Template One way is to use the collection CustomDocumentProperties. Tag: Visual Studio Tools for Office Cache data in workbook created from addin Office

Johan Nordberg

For VSTO documents and templates there's a really nice feature that allows you to cache data in the document. Is this functionality available when you create a new workbook from an addin

Re: Visual Studio Tools for Office Cache data in workbook created from addin

Cindy Meister

No, it's not. Data caching is added to document-level customizations through the VSTO Designer. It's not available otherwise.

Of course, you can access most parts of an Excel workbook through a data connection (OLE DB or Jet Engine ODBC)...

Re: Visual Studio Tools for Office Cache data in workbook created from addin

Maarten van Stam

Adding to the comments given by Cindy, she is basically right, there are however some working methods that allow you to make things work.

What you could do is create a Template with VSTO containing several cache entries to your own liking and have another addin create documents based on this template. After creating the document containing the cache entries you can access these cache objects through the ServerObject interface. When the document is then opened the data is available to work with.

I'm not sure this fits in your scenario and hope I gave you some hints here to get you going ...

-= Maarten =-

Re: Visual Studio Tools for Office Cache data in workbook created from addin

Johan Nordberg

How much data can you store in a custom document property

Re: Visual Studio Tools for Office Cache data in workbook created from addin

Cindy Meister

255 Characters. Excel doesn't appear to generate an error if you try to save more, but when you query the property only 255 characters are returned...