I'm writing a VSTO add-in to add a button the Standard toolbar for all new MailItems in Outlook 2003. I've got it mostly finished, but I can't see to work out how to set the button's position on the taskbar I'd like to place it right next to the Send button.Here's the code I have so far.
Private Sub colInsp_NewInspector(ByVal Inspector As Microsoft.Office.Interop.Outlook.Inspector) Handles colInsp.NewInspector
[Code]...
I am trying to save a ListObject from a .NET 3.5 Excel 2007 VSTO Workbook to a new sheet (done) and save that new sheet to a new workbook (done) without that workbook requiring the VSTO customization file (!!!!!).
Has anyone had any luck with this? The only way I've had any success is just saving as a CSV file but that's not exactly acceptable in this case. I'd rather not save to a CSV just to copy back to a XLS file.
worksheet.SaveAs(saveDialog.FileName, Excel.XlFileFormat.xlOpenXMLWorkbook)
I have a VSTO application, rendering a word documement. At each stage of the rendering a popup window is getting displayed. What we have done is displayed a popup window, and at each stage of the rendering the text is made Changed. I need to display the window using multithreading. How to achieve this.
View 1 RepliesI've developed a Word template in VSTO. When published it consits of several files including a Setup.exe, several msi files etc.Due to the fact that my company's security policy won't allow me to store dlls and exes on the server I need an alternative way to provide all the necessary stuff to the end user. I thoght it would be enough if I:
1) execute the setup.exe file on each client machine (it says everything got properly installed)
2) upload the xxx.dotm file to sharepoint and register it
3) edit policy settings
but it doesn't. When a user creates a new Document inside sharepoint using "New"->"xxx" the requested document loads without any error message and show the document but Word won't load any extensions / ribbons etc.
I've never worked with VSTO and I've recently read all kinds of stuff about it. So I ask a theoretical question. I'm trying to make an addin which should (using buttons in it's own ribbon tab) upload the document to my website (it's like slideshare). The problem is that this file may be already uploaded and the user may be just trying to update it.
So I need a way to tell if this file has already been uploaded. I know the prediction can't be 100% accurate, that's why I'm going to ask the user with a dialog, but I need it to be fairly clever to alert the user if the file MAY BE is already uploaded.
This assumption can be client-side only, with a database of some sort (in the addin itself).I thought of recording the file's name and based on this I can decide if the file is new or it's already uploaded.
PS. Working on Office 2010 with the latest version of VSTO in VS 2010. My main .net language is VB but samples in C# are more than welcome (if you have ones).
In Shared add-in the following event handler code for add-in start up is as follows:
Public Sub OnStartupComplete(ByRef custom As System.Array) _
Implements Extensibility.IDTExtensibility2.OnStartupComplete
End Sub
[code].....
I wanna ad a group on the main tab of compose mail, like in this picture.
View 1 RepliesI wrote this little AddIn sample to show you a performance issue and how to avoid it?It is just a parse of an excel workbook and runned in the main excel process (0) and a random thread created by the timer.
Public Class ThisAddIn
Dim a As System.Windows.Threading.Dispatcher = System.Windows.Threading.Dispatcher.CurrentDispatcher()
Dim t As New Threading.Thread(New Threading.ParameterizedThreadStart(AddressOf threadTest))
Dim tm As New System.Timers.Timer(20000)
[code].....
I need create a dockable window for my Visio 2010 add-in developed with VSTO, however I see no way of creating a task pane for Visio.
View 3 RepliesI need to call a VBA Function (accepting parameters and returning values) from a VSTO Add In Code base. The macro code base in the .xlsm file is as follows[code]...
View 7 Repliesthis forum is for VB.NET questions only (e.g. Visual Basic 2003, Visual Basic 2005, Visual Basic 2008).For VBA (Visual Basic for Applications), Macros or Excel Questions you will get better support in the VBA Forums:Visual Basic for Applications
[code...]
I have a VSTO Outlook 2007 add-in that loads on startup. When it loads it does the following: [Code] When the email is sent the app works fine. But when I click on the Button, then the add in fires 2x times and when I use the context menu it also fires 2x times. Any idea why this might be?
View 2 RepliesI have looking for a tutorial or class that demonstrates more than a trivial example of saving a windows position on closing. The ones I have found don't seem to work on all systems because of:
1. Multiple monitors. (and resolution between those monitors)
2. Toolbar size and position (toolbar is only on the primary monitor, well sometimes)
3. Sometimes the programs dont open on the right monitor they were closed on.
Is there an extensive class or tutorial on all the stuff a programmer needs to get right to have a window size and position persisted between executions?
I am using the following code to populate data in Textbox1:
[Code]...
I have few functions assigned in TextBox1_TextChanged event. The problem i am facing is this event is fired twice, once after the Fill command and another after the Position command whereas i want the event to fire only once after the Position command. What should i do?
I'm trying to use the System.Windows.Forms.MonthCalendar control within a VSTO Excel workbook. I want the MonthCalendar to pop up when I click a button in the ribbon, but so far I can't get the control to display at all.
Private Sub DeliveryDateFromCalendarButton_Click(ByVal sender As System.Object, ByVal e As Microsoft.Office.Tools.Ribbon.RibbonControlEventArgs) Handles DeliveryDateFromCalendarButton.Click
[Code].....
How to find Range with same font in document using VSTO
View 1 RepliesIs there anyway to use VSTO 2008 with the Office 2010 beta? I know I can use VB 2010 beta but I prefer to use 2008.
View 2 RepliesMy google skills have failed me on this, so I'm hoping that someone could point me in the right direction.I have a windows forms application that writes data to a datatable, which is then manipulated & saved into an access database. I am now looking to retrieve the data and write it out into a word document.
View 3 RepliesI have set up a timer in an Office addin (being developed in VB.net) that I can set going fine, using the code:
[Code]...
Anyone know of a way to see if the Excel window of a VSTO project is active/in focus?
I'm looking for an equivalent of System.Windows.Window.IsActive.
I would like to automatically create an Outlook rule (move email containing something in subject to folder xyz) but dont know how to achieve this. Of course I can create the rule and export it to a .rwz file. This file can be imported manually, but how can I import it automatically?
Can I import a rule through my VSTO 2005 Outlook (2003) Addin? Or can I create the rule from within this addin?
I am designing a shared add-in using VB.Net 2008 and VSTO that has to fire up when any MS Office App is started. It has to work for both 2002, 2003 and 2007 applications. I have managed to put together a working add-in that pops up a test message stating the version of Office and the Application name and tested this across all the apps ok.
The next part of the solution is to code the application specific code that needs to run for document auditing and corporate protective marking as well as, for example; in Excel checking that all the Add-Ins are linked to the Network Add-Ins folder.
My approach from now was going to be to late bind against the application object and set one of my typed (e.g. Excel) application object references which exist in the code to this object.
I've built a VSTO add-in for Microsoft Word and deployed to a webserver. Installation goes off without a hitch. When I create an updated version of the application and redeploy it to the webserver, the add-in correctly detects that there's a new version and attempts to update it. This is where I'm running into the following error (the "xxx" indicates that I had to censor something):url...The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the customization,first use Add or Remove Programs to uninstall this program: xxx. Then install the new customization from the following location: url...This appears to me as if I left a local reference of some sort in my Project, but I can't find anything of the sort. The only reference to this file is within the xxx.vbproj.FileListAbsolute.txt file that's generated in the bin/Debug folder.Not sure if this is also a clue, but I'm seeing Registry Keys added referencing this as the location of the VSTO Project Manifest.
View 1 RepliesCreate a simple VSTO Powerpoint 2010 AddIn with 1 toggle button inside the Ribbon.Open several presentations, then clik on the toggle button.he checked state of the toggle button is shared between all document.
View 1 RepliesI'm using a background worker to in an Excel VSTO application to throw up a progress dialog box with a status bar and a cancel button to escape from long running calculations. It's working really well, except for one issue. I'd like to use a Modal Dialog, so that the UI behind the dialog gets locked up, instead of a Modeless Dialog. If I use .ShowDialog() instead of .Show(), everything is great until you hit the Cancel button on the form. Following things in the debugger, the cancellation happens, it just takes somewhere in range of 30 seconds. If I use .Show() on my form, then the cancellation occurs immediately as it should.
[Code]...
I also have a function that returns ALL tiles on the map and they're X, Y position. How could I find out which one is closest to the position I specify? I can't figure out how to go about it. how to implement it with this. Heres a MADE UP example if what I'm trying to do:
Dim MyPosition as New Position()
MyPosition.X = 400
MyPosition.Y = 400
Dim tList as New List(Of Tile) = MyMap.GetTiles
Now, I can already do the stuff above, but what I need to make is something like this:
tList.GetTileClosestToPosition(MyPosition)
explain the use of "imports" at the top of each module. i am stumbling through development of an excel app in vsto and learning as i go.
in my project references i have added references and imported namespaces of everything that looks relevant to excel and office. am i then to add "imports" to the top of each module where relevant.
[code...]
before i added the imports microsoft.office.interop.excel i had no access to xldirection method. what other import namespaces(????) are needed and in what modules?
i have a couple of books that i am referring to, but none seem to start at the beginning and explain what this imports does / is for.
I would like have a progress bar like Outlook 2007. when you click on a link in a message. you can see a progress bar between the ribbon menu and reading pane in outlook 2007.
Is it possible to have the same progress in Excel 2007?
I have two forms: Main and Options.Main can be moved around the screen (like a normal window).When the user clicks a button, the Options form opens up and the Main form HIDES.How do I set the Options form to open in the exact place that the Main form was last on the screen (to give it the effect the MAIN form never went into hidding)I was thinking to set Option form's StartPosition to Main's current position, but I don't know the syntax for that or if it's even something you can do.
View 4 RepliesI have a chart in Excel that I'd like to use a subtitle on. There is no SubTitle Property on the chart object, so I looked in the Excel User interface and found that you can only create a sub-title by using a text box. The text box looks like its associated with the chart, not the worksheet, so how would I access that text box from code?
View 1 Replies