Office

Page 134




  • Topics
    Replies
    Last post
  • get started for VSTO SE and Excel 2003
    by ZZhang
    3 Replies
    Last post by Creamportion
      • Hello, I am new to VSTO, and like to learn. Is there sample or walkthrough for VSTO SE and Excel 2003 I'd like to use new SE version and not office 2007. Thanks! -Z
  • using VSTO w/ ASP.Net 2.0
    by den2005
    14 Replies
    Last post by den2005
      • Hi, Newbie using VSTO and developing office applications. The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done I installed PIA, VSTO2005SE w/ runtime, MS Office 2003 Web Components and will use MS Office
  • A question about office clipboard
    by Jin RongBo
    3 Replies
    Last post by Jin RongBo
      • hi, i have hooked two api: OleGetClipboard and GetClipboardData. when we copy some data , the OleGetClipboard is automaticly called by office clipboard, when we press ctrl+v in a office document, the OleGetClipboard also be called. until now , when OleGetClipboard is called, i can know which process called the function,such as winword.exe, but i cant know exactly who is the caller , the docume
  • Using legacy VBA code in .NET and VSTO solutions
    by NCGordon
    8 Replies
    Last post by Steve Hansen
      • Hello: During the transition from VBA tools to .NET tools, and as a stop gap, we would like to call existing libraries of VBA macros from new .NET solutions, whether in Office 2003 or 2007. We've got tons of legacy code in MS Word and Excel templates which still work perfectly well, and would be far too costly to completely overhaul/migrate to .NET. I've looked without success fo
  • Can't load my com add-in in outlook 2003.
    by JessicaZh
    4 Replies
    Last post by sklett
      • My com add-in was working well with outlook 2003, but was not loading in office 2003. It will load though if I run through the code. After running once through the code, the dll will load fine in Outlook. Does someone know what could cause this behavior Thanks.
  • Error while creating Outlook-Application-Object on OL2003/Vista?
    by Wuschba
    6 Replies
    Last post by Sue Mosher - Outlook MVP
      • Hi. I'm just trying to connect to Outlook 2003 from my C#-Application on Vista. I added "Microsoft Outlook 11.0 Object Library" to the references of my object, and then I'm calling: using Outlook = Microsoft.Office.Interop.Outlook; ... [STAThread] static void Main(string[] args) { Outlook.Application application = new Outlook.Application(); } Thats all, but I get the error: Retrieving th
  • Install com add-in
    by YaelS
    4 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I created shared com add-in in vs.net 2003 for outlook 2003. 1) I cant'n find the way to disappear my button add-in into the outlook toolbar after the uninstall. I still see this button! Only if I set reset toolbars, this button is disappear . I set in my code temporary = true.. Help me please with this topic. Code Snippet public void OnStartupComplete( re
  • Freezing Panes on a non-active sheet.
    by Edward Chan
    1 Replies
    Last post by Cindy Meister
      • I do know you can freeze a pane on an Application.ActiveWindow, but how do you freeze panes on worksheets that are not active I only have one window per workbook, so is there a way to freeze panes on all the worksheets in a workbook without switching focus to each worksheet
  • Convert Type "Shape" To "Chart"
    by Lihong
    5 Replies
    Last post by Cindy Meister
      • I have a PowerPoint 2007 AddIn project. In the project, a chart is added dynamically. I would like to convert the added "Shape" to type "Chart", and so I could access the datasheet behind the added chart, because I could not find a way to access data behind a "Shape" object. However, it seems shape interface cannot be converted into chart interface. See below:
  • Analysis ToolPak Functions Become Disabled
    by Scott Lock
    3 Replies
    Last post by Anonymous (2)
      • After installing a custom Add-in built using VSTO2005 (C#), the Analysis ToolPak seems to become disabled. Checking the "Disabled" status of addins under help and in the registry shows that it is actually enabled. However, all of the EONAME functions have now become "Unavailble". Has anyone seen this behavior Scott
  • Problem Reading Excel Dates. Excel date gets converted to Double value in DotNet
    by Darshan Parekh
    2 Replies
    Last post by Darshan Parekh
      • Hi, I need to upload the data in excel in to MSCRM. I am using ExcelSnapIn for this. While reading cell by cell data, i am facing very wiered problem. The Date value in Excel is getting converted as double in the dot net code. My code looks like this. Dim Sheet1 As Excel.Worksheet = DirectCast (Application.ActiveSheet, Excel.Worksheet) Dim rng1 As Excel.Range = D
  • Fill in outlook appointment from dotnet application
    by zaabdullah
    8 Replies
    Last post by David Hernandez Diez
      • Hi I have dotnet 2005 application.I want to fill appontment from my customer data programaticaly.If any one can help on this please. Zaabdullah
  • VS 2005 Tools for MSOffice System
    by Binnit
    1 Replies
    Last post by Cindy Meister
      • I am pulling my hair out and beginning to think I have made a big mistake buying this product... can someone put me straight We have a number of Access 2003 db's and wanted to deploy some using the runtime option so that other users did not require Access on their machines. To do this, we concluded we needed VS 2005 as it clearly states on the package that it includes "MS Office
  • What is the best way
    by Pierre Savard
    1 Replies
    Last post by X4U
      • I need to track some email and send it trough a web service to a database. I track all incoming email in thne NewMailEX function and store de EntryID in a collection. A timer in another thread (to be shure that i do not miss NewMailEX event) take the entryID in the collection and send it to the web service. If the web service stop responding, I whant to save the entryID in a outlo
  • Outlook 2007 and 2003 problem
    by HawVer
    3 Replies
    Last post by Bill Robertson - MSFT
      • http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1323324&SiteID=1 I'm running into the same problem. I once installed a beta version of 2007. After working with it for a while, I removed it from my system and installed version 2003. Now when I want to make a new VSTO project, the Microsoft Office 11.0 Object Library is pointing to a version 12 dll. I assumed that the problem was in th
  • Excel Paste special
    by Tim5827
    1 Replies
    Last post by Dennis Wallentin
      • Do you know what is wrong with this code This same question was asked in another forum with no answer. public void PasteValues() { Excel. Range r = (Excel. Range )Application.Selection; r._PasteSpecial(Microsoft.Office.Interop.Excel. XlPasteType .xlPasteValues, Microsoft.Office.Interop.Excel. XlPasteSpecialOperation .xlPasteSpecialOperationNone, System. Type .Missing , Syste
  • Excel Save and SaveAs method throws exception...
    by DrLeary
    3 Replies
    Last post by Cindy Meister
      • Hi! I'm trying to save the currently opened Workbook using the SaveAs method as shown here http://msdn2.microsoft.com/en-us/library/h1e33e36(VS.80).aspx but it keeps throwing this exception: "Old format or invalid type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))" So I tried using the Save method, which takes no parameters, but the same result=( Thi
  • VSTO se sorting problem
    by MothDoc
    13 Replies
    Last post by MothDoc
      • Hi Ji I am trying to do something similar but I am afraid I am getting nowhere. I am trying to build a function within excel that will allow one to stipulate the performance of calculations and other formulae based on the cell background colour. For instance I have a column of figures B2:B9 with the following values and cell colours B2: 2 pink B3: 3 white/no colour B4: 0 pink B5: 0 white/no colo
  • Deploying VSTO SE addin : Is there a Debugging Utility available
    by Nitstheone
    7 Replies
    Last post by Nitstheone
      • There are so many people having deplyment issues on end user machines (including me ), I am wondering if there is a troubleshooting utility, which would check if the environment is ok and generate a log. My problem : Addin does not load in excel (LoadBehavior=2) on Virtual PC VPC(2004sp1) is using Win xp SP2, office 2003 SP2, dot net 2.0,PIA, VSTOR and nothing else I have developed a
  • UserDefined properties displayed empty?
    by Jonathan Miller
    2 Replies
    Last post by Jonathan Miller
      • I'm trying to program Outlook 2007 using VSTO 2005 SE. Basically, I've created a folder with user defined properties. I've created items in the folder and set the properties using the PropertyAccessor. I can even enumerate the items and read back the properties values. However, when I add my UserDefinedColumns to my view there is nothing in them! What is the deal. It makes me think that the values
  • VSTO: Straight from the Experts Web Cast Series
    by Mike Hernandez - MSFT
    6 Replies
    Last post by panon
      • Be sure to join me in a series of webcasts in which I chat with VSTO experts such as Ken Getz, Tim Huckaby, Paul Ballard and Robert Green. They'll show you examples of what they've been doing with VSTO and share their thoughts about what you should know as you're using VSTO to develop Office business applications. Below you'll see links to the first three webcasts in the series. You can als
  • How to start VSTO
    by Geethanga
    2 Replies
    Last post by Geethanga
      • Hi all, I'm a VSTO beginner. I want to get step by step information on how to create a vsto project. I want to develop it for word 2003. And i'm using Visual Studio 2005. 1) What do i have to download 2) In what order i have install them 3) And a small complete guided tutorial ... Thanks in advance... Regards,
  • How to get the Range that contains a control.
    by mathmax
    5 Replies
    Last post by mathmax
      • Hello, I've a control in my word 2007 document and I would like to get the Range that contains it. If the control already exist on my page, I know I can add a bookmark around it and then get the Range via the Range property. But if the control is added at runtime, I don't find a way to add a bookmark around it... As a general rule, is there an other way to find the Range that contain
  • VSTO over VBA
    by Muralidhar M S
    12 Replies
    Last post by Cindy Meister
      • We have hundreds of Excel tools to automate. What makes VSTO better than VBA to automate Excel Getting Visual Studio or the framework installed on user machines is not a problem.
  • How to get the charts in the Excel sheet and write it to word document
    by Kesava
    1 Replies
    Last post by Cindy Meister
      • Hi all, I have some predefined charts in the excel that are generated using VBA code.I want to write a C# program to select those charts and write it to word document seperately. regards keshav