I 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)
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'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
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.
I'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.
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 want to import data from excel and move that to Datatable in VB.NET 2008. I wrote and working but its taking too long time.. for 1500 records its taking 4.40 min.
I 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?
I am using VS .net 2003 and developing a program that calls Excel. The development computer only has Excel 2003, and the target machine only has Excel 2007. Would it be possible to install Excel 12 Object Library in the development computer without installing Excel 2007?
I'm trying to upgrade a VB6 app to VB 2008. I have read the article in the tutors corner about automating Excel from VB but I cannot get it to work. Heres what I have done:
1) set a reference to the Microsoft Excel 12.0 Object Library
2) Added "Imports Excel = Microsoft.Office.Interop.Excel" to the top of the module
3) in a routine I have added: Dim X As New Excel.Application Here's where I get an error: Error 75 'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel'.
Dim exlapp As New Microsoft.Office.Interop.Excel.Application Dim xlWorkBook_new As Microsoft.Office.Interop.Excel.Workbook Dim strOriginal As String strOriginal = Server.MapPath(Request.ApplicationPath & "/Attachments/") & "abc.xls" xlWorkBook_new = exlapp.Workbooks.Open(strOriginal)
The code hangs in the last line. It works fine in the development environment. i deployed in windows server 2000 ,where I get this issue. the browser goes half way and throws the below exception after some time
[Code]...
I have set the identity impersonate to true in web config. This should be mostly an access rights issue.I have even provided access rights for the "everyone " user in the excel file and as well for the interop component. Please post ur valuable comments.
I'm trying to create a pivot table by opening an Excel file from my drive.But I'm receiving the error saying "Object reference not set to an instance of an object".[code]
Basically I've coded an Excel 2007 project in VB.NET 2010 that allows you to create charts with a fair amount of interactivity. I want the user to be able to save and reopen this workbook and still have that interactivity in any already-created charts, so they don't have to re-create them.
When I create the charts, I use Sheet1.Controls.AddChart(...), which returns a Microsoft.Office.Tools.Excel.Chart with which I can handle events and such. However, when I reopen the file and look through the Sheet1.Controls collection, there are no Chart objects. Accessing the charts through Sheet1.ChartObjects.Chart gives me Interop Charts, when I need the Tools Charts.
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.
I'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'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
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).
I 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]...
this 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
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?
My 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.
I am using VB Express 2008, and I am trying to create a COM object to use in Excel. I have looked at the walkthroughs, but it seems they only apply to Visual Studio.
Is there a way to create a COM object in VB Express?
