Office

Page 358




  • Topics
    Replies
    Last post
  • The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
    by IainDowns
    3 Replies
    Last post by HippyPete
      • I'm not sure this is the correct forum, if not please can you direct me accordingly. I'm trying to extract data from Excel 2007 using OleDB. I've downloaded and run '2007 Office System Driver: Data Connectivity Components' and the installation appears correct, but when I try and open a connection (from c#) I get the error above. I don't know how to check if the driver is really there. It
  • single setup for Word, Excel, ppt?
    by Malleswar
    2 Replies
    Last post by Malleswar
      • Hi, I want to add tool bar to Word, Excel, ppt. when they click on tool bar buttons the functionality is same which has to be performed in 3 applications( word, excel, ppt). I want to achieve this with single setup file. currently I am adding separate project file (addins) for each, then automatically it adds separate project files. Can any one please guide me Thanks in Advance,
  • How to save Excel object for further use?
    by BlackBar
    14 Replies
    Last post by BlackBar
      • Hallo. I'm writing AddIn for Excel 2007 in C#, using VSTO 2005 SE. I'd like to have possibility to use something similar to templates - specially saved Excel objects (for example: a pattern of the table) for further use. For example: I'll create an Excel table which represents information about person (Name, Surname etc.) and I'd like to paste this table in a Worksheet, allow user to fill it and
  • Outlook: MAPI fields versus User Properties
    by MauricioUY
    14 Replies
    Last post by Ken Slovak
      • Hi, I want to improve an outlook addin which is using mapi fields (a lot) and this is generating abnormal behaviors in outlook, so now I'm in doubt to quit all use of mapi fields fo User Properties but I need some recomendatios or comments about using "mapi fields vs user properties" (or viceversa). Thanks, Mauricio.
  • Two MeetingItem questions
    by fahad11
    8 Replies
    Last post by fahad11
      • hi guys... i am doing an addin on outlook 2007 using vsto se (c#) so i want when i recieve a new meeting ...to add it to database but the problem is that i couldn't deal with the MeetingItem ...to be more detailed i didn't know how to access the subject , date & other stuffs of the Meeting... so could some one kindly explain to me how to achieve this my other question is
  • Reducing Dependencies
    by BenDowling
    3 Replies
    Last post by Geoff Darst - MSFT
      • VSTO projects have a huge amount of dependencies! Is there any way to reducde the number of external dependencies For example, can I set the "Copy Local" attributes of some of the references to true, and bypass the external requirement If so, what external dependencies are you remove the need for, and how Many thanks, Ben
  • Writing to excel spreadsheet
    by TonyFlora63
    4 Replies
    Last post by TonyFlora63
      • HI I'm reading from a text file and trying to write all instances of ADAM to a spread sheet. My end result is that the machine name in the first column is overwritten by the next machine name in the text file. Also I would like to write this data to a spread sheet that is closed instead of being open at the execution of the script. Here is my code: '---Declare Variables--- Dim
  • Legacy Forms and VSTO 2005 SE Addin Connectivity
    by D Mccreadie
    2 Replies
    Last post by D Mccreadie
      • I am trying to convert a VSTO/Outlook2003 addin that uses custom forms to run under VSTOSE/Outlook2007 with the minimum of rewrite possible. I have got to the point where the majority of the addin code is happy with the change to the template BUT I have hit (what seems to be a perennial) problem with accessing the Addin from VBScript in the custom form. I had been using the workaround recommend
  • How can I use VSTO to import manual tests into VSTS for Testers (manual Word format)?
    by abutters
    0 Replies
    Last post by abutters
      • I sent an email to an MSDN Blog regarding the importing of manual tests into Team Edition for Testers. "...I need to translate thousands of manual tests written in Excel into an electronic system to manage and execute multiple MANUAL test runs for multiple products (high level end-user functional stuff). As far as I can tell, the Team Suite does not have the capability to mass im
  • fastest way of naming huge number of cells
    by Manash
    1 Replies
    Last post by Dennis Wallentin
      • Hi, In our VSTO application we have to give individual cell name for huge number of cells (more than 100000 cells) and we found giving name to a cell is taking time specially when we have already 50000 named cells in our excel. What is the fastest way to providing name in this scenario. Please help.
  • Outlook.AppointmentItem.Conflicts - Problem
    by Iram
    14 Replies
    Last post by Iram
      • Hi, I'm writing an AddIn Outlook application, that should create new Calendar instance. In this new Calendar I need to check each change in each item if it has any conflicts with other Calendar item. I tried to use Outlook.AppointmentItem.Conflicts member but its count property always equal to 0. What am I doing wrong Thanks, Iram.
  • Excel worksheet ActivateEvent
    by jacknsa
    10 Replies
    Last post by jacknsa
      • Converting some VBA to VSTO. Trying to wire up worksheet event handler at run time - using VB. Works fine for most events (Deactivate, BeforeDoubleClick, etc) but can't assign ActivateEvent handler. What am I missing
  • Desperately need help for inserting an html page/image in the body of the outlook appointment
    by da_coder
    1 Replies
    Last post by Peter Jausovec
      • I am at the end of my witts and have spent a lot of time trying to get this sorted, but am unable to insert an image/HTML page, programatically into the body of an appointment. I am a new bie in outlook application devlopment and any help help would be highly appreciated.... cheers
  • Outlook Add-in Distribution and CDO
    by mkelly4ca
    6 Replies
    Last post by mkelly4ca
      • I have created a VSTO add-in that uses CDO. It's installed with Windows Installer (following the directions at http://msdn2.microsoft.com/en-us/library/bb332051.aspx ). CreateObject("MAPI.Session") throws an exception "Cannot create ActiveX component". I've searched in vain for a solution, but all I can find are people suggesting that CDO isn't installed or registered, and that
  • VSTO and Microsoft Office
    by mjj0000
    11 Replies
    Last post by pmcdermott
      • I am having trouble getting VSTO to work. When I go into Visual Studio to create the project I get a cryptic error telling me to check for disabled items in Excel (I have none) and then it instructs me to reinstall VSTO. A classmate suggested that it is because the University edition of Office (Microsoft Office Professional Enterprise Edition 2003) is crippled. Can anyone confirm if this is
  • Outlook undo statck
    by DoWang
    4 Replies
    Last post by DoWang
      • Does Outlook allow us to maniputalte the Undo stack of HTML Editor Anything like "ClearUndoStack()" or "UndoLastOperation()"
  • To format a column of Excel to Text
    by Anpiro
    1 Replies
    Last post by Dennis Wallentin
      • Hi! I am trying to format a column to text and cannot. The failure this one in (Excel. Range) worksheet. Cells [1, 3]) .EntireColumn. NumberFormat = "*"; I must use another method but not which Can they help me
  • Word 2007 Add-In installation on Vista
    by DBogucki
    3 Replies
    Last post by DBogucki
      • I seem to have hit a brick wall and cannot find a satisfactory work-around for my VSTO 2005 SE Word Add-in installation on Vista. Developped with VS 2005, it's an Office 2007 Add-In, which requires the installation to be "per-user", but the .Net Code Access Security modifications needed requires the user installing the add-in to run with administrative rights. Idealy, I would like
  • C# function call crash
    by YP1
    2 Replies
    Last post by Cindy Meister
      • There is a C# code which worked reasonably well when it was compiled with .NET 1.1 and Visual Studio 2003. Now we have switched to .NET 2.0 and VS 2005 and some machines started displaying strange behavior. It is demonstrated in the code below: Something like GPF happens in the call to Foo.Bar(). The execution does not go inside the function, it looks like .NET runtime which does the call, crashes
  • How to know what documents already loaded
    by Aleksey Nagoga.
    4 Replies
    Last post by Aleksey Nagoga.
      • I'm working with VS 2005 and Office 2007. I'm adding a custom pane, but I want to display it only when a particularly named document is being opened. The problem is that when I open a document that is already opened, Winword still fires the Application_DocumentOpen event, like if it was really opening the file, when in reality it just switches focus to the already opened version of it. This behavi
  • SQL DBA Needs help with Word Document Creation, using VSTO
    by Rob Lewis
    1 Replies
    Last post by Douglas H. Troy
      • Like the subject says I am a DBA, not a word macro programmer, But the Boss says since this is running from the server its a server project so here goes. I have created a Word Project using VS.NET 2005 and Word 2003 Template file and a code behind page. When the Template file is opened, it opens a recordset and generates a letter using the information in the recordset, it then saves the fi
  • Error: Project cannot be created because the application add-in is not working correctly
    by Helori Lamberty
    3 Replies
    Last post by mathmax
      • Hello,   I h'ave a problem with Visual Studio 2005 (Team edition for software developper), when I create a new Excel Workbook project, this error appear: Project cannot be created because the application add-in is not working correctly and might have been disabled.  To check for disabled items in the Microsoft Office application, open the help menu, click About Microsoft Office
  • Color type conversion in Word 2007 Addin project
    by Syed Raza
    4 Replies
    Last post by themadhatter0110
      • Hi all, I have a Word 2007 addin project and need to set font formats/colors to some document text. I can only able to set the Range colors through Word. WdColor constants. What i am looking for is to cast System.Drawing. Color to the wdColor and unable to do it programmatically in c#. Sample line of code is: rng.Font.Color = (Microsoft.Office.Interop.Word. WdColor ) System.
  • property bag limitations
    by tr7
    13 Replies
    Last post by Misha Shneerson - MSFT
      • Hi, I'm using a regular expression in my Word project and I'm using named groups in the regex. I know that VSTO creates a property bag to hold the key/value info corresponding to the named group. However, one of the named groups in my test document contains 550 characters (with spaces). In my regex editor, the entire expression is recognized with no problem but in VSTO the expression fails. I c
  • VSTO Excel very slow
    by jk_uk2
    6 Replies
    Last post by Dennis Wallentin
      • Hi, I have an Excel add-in wrritten using VSTO SE that I'm having a bit of trouble with. I have two issues: 1)Outputting approximaltely 300 rows of data to Excel takes much longer that it would do in VBA. 2)The windows forms in the add-in are also a little slow to load. The slow outputting of data is the main issue. I have set calculation to manual, turned off screen updati