-
- Index was outside of bounds of the array error in VSTO Excel application
by Dmitry Kholodkov
- 1 Replies
- Last post
by Cindy Meister
- We are encountering an error in an application when we are trying to import XML data
Te application is an Excel smart document. The error is being reproduced all the time.
The sheet data is being populated but with an exception that returns "Index was outside of bounds of the array" error
Microsoft.Office.Interop.Excel. XlXmlImportResult xl = new Microsoft.Office.Interop.Excel.
-
- VSTO SE ClickOnce + User prompt
by Kulvinder
- 2 Replies
- Last post
by Denis Pitcher
- Hi,
I have created a simple "Hello World" VSTO 2005 SE Outlook 2003 Addin. I have published it on my network and it is working fine. I want to know that if i need to have an automatic update through ClickOnce, is it possible that i can have a User prompt in case the dlls deployed on UserMachine are of an older version. Right now, my program is doing this silently but i want that t
-
- How can I find out if Word is loaded in Outlook?
by vitich
- 4 Replies
- Last post
by Sue Mosher - Outlook MVP
- I'm creating Word Addin with VSTO 2005 SE. I need to disable some functionality in case Word loaded in Outlook (when I compose email for example). How can I find out if Word is loaded in Outlook
Thanks,
Victor
-
- Intermittent HRESULT: 0x800A03EC setting value in a cell
by rfl
- 1 Replies
- Last post
by Andrew Whitechapel - MSFT
- Hi, I get this error intermittently (here's the error, stack trace and code): Exception from HRESULT: 0x800A03EC Server stack trace: Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Microsoft.Office.Interop.Excel._Work
-
- Fixing Bad Office.Core Refernce in xl2003 Application Add-In
by Greg M
- 11 Replies
- Last post
by Cindy Meister
- Hope I'm nearing the end of questions here, and thanks again for reading.
I have a Excel2003 Applcation Level Add-In made using VSTO with SE download.
Deployment package is made, I can see that registry entries are being made, that CAS policy has full trust and that prereqs are loaded.
I have set the suppressdisplayalerts environ variable =0 to see why the add-in is not loadin
-
- Cached Data from Website to Word Doc
by gbobg
- 1 Replies
- Last post
by gbobg
- Hello, I am having an issue with cached data in a Word document that is getting setup by a web page, but it only has an issue on the web server. I have a word document report that is being triggered to open from a web page and it is auto populating based on cached data and a web service. The code is very similar to the Benefits Registration Sample:http://msdn.microsoft.com/library/default.asp url
-
- Excel Debugging
by A7Zulu
- 2 Replies
- Last post
by Ji Zhou ¨C MSFT
- I am trying to create a DLL that Excel will use, how do I debug my functions from Visual Studio I believe I have set my properties correctly, but nothing loads.
Thanks,
Aaron
-
- Minimum Office 2007 version required for VSTO
by Babba72
- 2 Replies
- Last post
by Babba72
- Hi, i have to understand wich minimun version of Office 2007 can run VSTO solutions (not VSTO 2.0, old solution VSTO) made with framework 1.1
I have searched on Office web site but i'm not able to get this information (there are several versions of Office...)
In Office 2003 it was required PRO version (the standard and small businnes version not have programability .NET)
Thanks in advance
-
- VSTO Excel Referance question
by lrjanzen
- 1 Replies
- Last post
by Ji Zhou ¨C MSFT
- I am consolidating the saves for a number of worksheets in the ThisWorkbook.vb. I hve a menu that calls a save event handler. Each worksheet has several data bindings and lists that need to be handled uniquely on each worksheet.
for instance on Sheet1.vb I have
Me .BeBindingSource.EndEdit()
or a sub
Private Sub SaveApprovalValues()
CODE HERE
End Sub
on Sheet2
Ho
-
- Conversion of Attachments embedded in an mail
by Alhambra Eidos Kiquenet
- 3 Replies
- Last post
by Sue Mosher - Outlook MVP
- Hi misters,
I want to access attachments of a mail (MailItem) and if attach type is olEmbeddedItem , convert it to olMailItem in memory.
Now, I have this code, saving attachment (.msg file) to disk and using CreateItemFromTemplate.
Another solutions without save to disk the msg file
Any help will be very grateful, thanks in advance, greetings, regards
The code here:
-
- Dynamic creation of CommanBarButton Issue
by Ilya Cherkasov
- 2 Replies
- Last post
by Ilya Cherkasov
- Hi everyone!
I try to make some logic with adding and deleting CommandBars within Word AddIn Project, so that my life gets easier when application business will make it's move.
I have ToolBarController component that can have CommandBars (or CommandButtons) created, deleted, locked, and so on. Here's a little of it's logic (yes it contains issue )
private void AddButton(
-
- Printing Word docs closes my VSTO template
by John Simons
- 6 Replies
- Last post
by John Simons
- I'm using Microsoft Visual Studio Tools for Office, and I have the following problem: If I create a new Word Template project (Visual C# | Office | Word Template) and then press F5 to start it up, it all works and MSWord2003 starts up as expected. But then if I right click on any existing Word doc file (no VSTO) and select Print from the context menu, my VSTO Template closes unexpectedly. I wonder
-
- How to get the icon for a given item?
by Dmitri Pozniak
- 2 Replies
- Last post
by Dmitri Pozniak
- Hello everyone, I am trying to get an icon for a random item -- e.g. MailItem or TaskItem -- that is displayed, for example, in a ToDo list, Reminders window, etc. The only thing I managed to do is:
Code Snippet
mailItem.PropertyAccessor.GetProperty("http://schemas.microsoft.com/mapi/proptag/0x10900003") and it returns a mysterious value of 2 Does anyone have any ideas on h
-
- Problem with custom Excel menu for copying sheet to new workbook...
by Sebastiaan Brozius
- 5 Replies
- Last post
by Sebastiaan Brozius
- Hi y'all,
I have a problem with an Excel AddIn. It's made with CS2005 and VSTO2005SE for Office 2003.
I have made a menu entry for copying the contents of the currently active sheet to a new workbook based on a template with a set header and footer, print that workbook and then close it without saving.
Works (finally!), but after doing this for, say, one or two times, all menu ent
-
- Outlook 2007 add-in o2007pia.msi install error
by E K R
- 4 Replies
- Last post
by Carlos Oropeza
- Hi,
I have developed an Add-in for Outlook 2007 and deployed it successfully on a couple different machines But with others I am getting an error when setup.exe is trying to install o2007pia.msi file. So then I try running o2007pia.msi on its own and I receive the error "Error 1316. Setup cannot read from file C:\Eric\PIAREDIST.msi. Check your connection to the network, or CD-ROM
-
- COM Exception in CommandBars["Task Pane"].Visible = true
by mobigital
- 6 Replies
- Last post
by John R. Durant - MSFT
- I am getting this occasional COM error when trying to ensure that Document Task pane is visible:
This code: Globals.ThisWorkbook.Application.CommandBars["Task Pane"].Visible = true;
Causes this exception: System.Runtime.InteropServices.COMException (0x80004005): Error HRESULT E_FAIL has been returned from a call to a COM component.
at Microsoft.Office.Core.CommandBar.set_Visibl
-
- Remove borders from Excel charts using C#
by becklighter
- 14 Replies
- Last post
by becklighter
- I am building an excel file from scratch. this includes charts of data. In this particular case I need to remove the borders from the chart, but it doesn't appear to work correctly. // The next three lines are an attempt to remove the border, the fourth shows that I am controlling the chart ((Excel.ChartObject)oSheet.ChartObjects("Chart 1")).Border.LineStyle = Excel.XlLineStyle.xlLineStyleNone;
-
- Is there any "Hello World" tutorial for an Outlook 2007 Add-in ?
by TomJ72
- 4 Replies
- Last post
by TomJ72
- When I tried to create an add-in for Outlook 2007, I thought everything went smooth and seemed okay, even compiling the project and starting outlook when I clicked the play button. However, nothing happened, i.e. the code in the method "ThisAddIn_Startup" does not seem to ever become executed, but I never get any kind of error message.... Here is what I have tried to do from Visual Studio 2005 Pro
-
- Need to add a folder-group at the root of the Outlook 2003 treeview..
by Hir&#2
- 4 Replies
- Last post
by Sue Mosher - Outlook MVP
- Hi,
I am working on an application which is has a Document Store and is supposed to be tightly integrated with MS Outlook 2003 ( which is s upposed to act as one of its client ).
Now, using VSTO, I am able to add the folder(s) under the current root folder
i.e.
- Mailbox <user name>
|--- Drafts
|--- Inbox
|--- <My Document Store Folder-Group>
-
- Extending Word 2007 Content Controls/Implementing the ContentControl Interface for our own Controls
by Toby Russell
- 1 Replies
- Last post
by Cindy Meister
- Hi, Is it possible to extend Word 2007 Content Controls in any way I notice there is a Content Control interface; could one develop custom Content Controls by implementing this interface I would also like to be able to modify the right-click menu, when over Content Controls in particular for Word, but also for Office 2007 in general Thanks, Toby
-
- Getting default Mso labels
by Jan Ku&#269;era
- 3 Replies
- Last post
by miloush
- 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
-
- MAPIFolder
by ANGanley MCSD
- 4 Replies
- Last post
by ANGanley
- Help Please.
I have the following code.
basically i want to access outlook contacts.
Imports Otl = Microsoft.Office.Interop.Outlook
Private Sub AccessContacts( ByVal findLastName As String )
Dim Outlook As New Otl.Application
Dim foldercontacts As Otl.MAPIFolder = CType (Outlook.CreateItem(Microsoft.Office.Interop.Outlook. OlItemType .olMailItem
-
- How to increase the size of an image in toll bar of excel.
by Bharanee
- 3 Replies
- Last post
by Cindy Meister
- Hi,
I'm using an image in excel tool bar. The image actual size is 135 x 90. But when it displayed in toolbar its 16 x 16. Let me know how to increase the displayed image size in the tool bar.
It will be very helpful for me to proceed further, if the solution reaches me in short.
-
- Getting Word compatibility/version info for active document
by wordyone
- 3 Replies
- Last post
by sdangelo
- I am working on a VSTO SE addin for Word 2007 (written in VB.Net). On the DocumentOpen event, I need to get information on what version of Word the document was created in.
This worked in prior versions of Word but seems to fail with Word 2007 object model:
App.Dialogs(Word.wdWordDialog.wdDialogToolsOptionsCompatibility).Product
The Product property is in the object model docu
-
- Problem looping through mailItems in Explorer selection collection in Outlook 2003
by planza
- 0 Replies
- Last post
by planza
- I am iterating through mail items in explorer.selection. If I select only 1 message, I can save it to a msg file with no problems. However, I get an invalid cast exception after the first item in my selection when I try to run my routine on multiple mail items. I have posted my source code below. I am vb.net 2005. Any help will be appreciated. Thanks. '-----------------------------------------