Office

Page 163




  • Topics
    Replies
    Last post
  • Outlook Add-in User Settings
    by supersonic1976
    1 Replies
    Last post by John R. Durant - MSFT
      • Hi, I am using the user settings in my COM Outlook Add-in using C#, but instead of storing the user settings under the ProductName folder thet are stored under a folder "Microsoft_Corporation". Any clue on this THanks, Hrishi
  • ColorFormat's RGB not available in C++/CLI
    by GrkEngnr
    3 Replies
    Last post by Geoff Darst - MSFT
      • I'm trying to use Powerpoint interop from a C++/CLI application. My problem is that when I try to change the color of added text, I can't get to the RGB property of the ColorFormat field. I usually set font size as shown below. slide->Shapes[ "TextName" ]->TextFrame->TextRange->Font->Size: et(FontSize); when I try the same with Color, I can see every f
  • unsubscribe or change handler for commandbarbutton click event
    by Ryan Garaygay
    1 Replies
    Last post by Rachel Schaw - MSFT
      • During startup, i create a custom toolbar with a button (say Button1) in it and subscribe (register/hook.. not sure about the right term) to the button's click event. Then i open another instance of the template, and check if the custom toolbar already exists and wanted to change the handler for Button1's click event. Assuming i already got to Button1 using FindControl: I can to unhook t
  • MS office automation - (AppID for PowerPoint to automate..)
    by milgurung
    5 Replies
    Last post by Misha Shneerson - MSFT
      • Hi, Server side automation of Office is not recommended but I have to deal with it. I got the solution at this link. http://support.microsoft.com/kb/288366/ and it provides the registry values to set for word, excel and access as [HKEY_CLASSES_ROOT\AppID\WINWORD.EXE] "AppID"="{00020906-0000-0000-C000-000000000046}" [HKEY_CLASSES_ROOT\AppID\EXCEL.EXE] "AppID&quo
  • Deleting Word menus
    by Gastiflex
    5 Replies
    Last post by Ji Zhou ¨C MSFT
      • Hi, I'm working on a Word2003 addin that adds some menus. When I uninstall the addin, the menus are still visible but are inactive. To delete them, I must delete the Normal.dot file. Is there a better way to do this, because I can't delete the user's Normal.dot file Thank you
  • How to add a scroll bar to scroll the contents of a cell
    by SkyKid
    2 Replies
    Last post by Cindy Meister
      • I have a worksheet with cells that hold a lot of overflowing information. I want to limit the height of a cell to a certain value and anytime after have a scroll bar appear for the cell. Is there a way to do that
  • PIA help
    by Mark Macumber
    3 Replies
    Last post by Mark Macumber
      • Im trying to write my own ribbons for Word 2007 and Im assured that its easy to do. But when I read pretty much every tutorial they say "go to the references, then click the .net TAB and choose the Microsoft.Office.Interop.Word" assembly and click OK. But that isnt even in my references. I have even downloaded the PIA redistributable from the Microsoft site, I have installed the PIA's, I
  • word Application.Quit fail in C#
    by 无&#2637
    3 Replies
    Last post by ?ÓÐ??
      • I callled the Quit method of Application,but the word process was not terminated. Details: Word.Application thisApp = new Word.Application(); Object templateFileName = @"C:/t.doc"; Word.Document thisDoc = Tools.openListTemplate(templateFileName, thisApp); //position A fillHead(1, 1, thisDoc); //position B fillItems(0, m_vehicles.Count, thisDoc); //position C
  • How to call stored procedure in Sql 2005 from Access 2002?
    by prads
    5 Replies
    Last post by Cindy Meister
      • Hello, I have a stored procedure in SQL 2005 'TransferNote' which accepts one parameter. How would I call that procedure from my Access 2002 database Thanks
  • Delete Chart Object after open up saved Excel file
    by bayitech
    5 Replies
    Last post by Cindy Meister
      • I've created an Excel 2003 add-in to get the contents from the file, and draw charts on the sheets. Since some of the file has different data, add-in application will refresh (delete all the charts and data plots) and then it will re-plot the data and re-draw the charts. It works fine when I open a new excel file and do it. However, charts objects don't get deleted once I re-opened a saved excel f
  • Office 2007 office type projects forced for .Net Framework 3.5?
    by Doriak
    9 Replies
    Last post by Mary Lee - MSFT
      • I have a confusion here. I installed the latest beta for Orcas. when I try to create a new project for Office 2007 I can only see the project types if I select the 3.5 .NET Framework. Why is this What happens if i want to use a 2007 Word or Excel project in a machine that has only 3.0
  • Interface not registered (Microsoft.Office.Interop.Outlook)
    by EB78
    4 Replies
    Last post by Andrew Whitechapel - MSFT
      • Hi all, i have the following exception in my Outlook addin. System.Runtime.InteropServices.COMException (0x80040155): Interface not registered (Exception from HRESULT: 0x80040155) at Microsoft.Office.Interop.Outlook.MAPIFolder.get_Folders() After installing my addin: in Win XP + Outlook 2003 it works fine, Win XP + Outlook 2007 also fine, however in Vista + Outlook 2007 if fail with exce
  • Newly Added Document is NOT the Active Window
    by pKulandrei
    13 Replies
    Last post by pKulandrei
      • Hi everyone, I created a add-in for Word using vsto. I got a form that show to the user and when a buttoon on that for was clicked, the add will add a new document using this.Documents.Add(<params>). The new document was successfully created but it was not the active window. The first document when I opened word was still the active window. I'm using Document.Activate() to make the ne
  • Publishing VSTO 2005 SE addin to a network location
    by Rakesh Rathod
    14 Replies
    Last post by techno_adi
      • Hi, I want to publish my Outlook add-in build using VSTO 2005 SE to a network location so that updates can be automatically pushed to all users later. The steps mentioned for this are as follows: In Visual Studio, use the Publish Wizard to deploy your solution to a server. Make changes to security policy so that each end user can run the solution. Create the required registry entrie
  • Is Microsoft taking problems serious?
    by Raptorix
    5 Replies
    Last post by Geoff Darst - MSFT
      • Today i came back from a 2 week holiday, before my holiday i had to investigate or InfoPath could be of use of one of our customers, i installed infopath 2007, and was looking for some developer tools for VS2005, since we want to use infopath serverside/webbased. After installing several servicepacks (why are those not advised in the microsoft updates ) i finally got what i want! (took me 4 hou
  • [C#][COM] Excel crashs when a cell name is a function name
    by nielsvanvliet
    1 Replies
    Last post by Mohit Gupta - MSFT
      • Here is how to reproduce the problem: 1. Create a C# COM server - Create a new DLL, with register for COM interlop - Add the code ( available below ). 2. Test - In Excel->Tools->AddIn->Automation , choose TestServerCom.TestServerCom - In cell B1 , type =Hello("niels") . - the value of B1 will be: "Hello niels!" ; 3. Test the crash - Select A1 - Define the
  • embeding data into word file
    by Job Lot
    10 Replies
    Last post by Ji Zhou ¨C MSFT
      • Sorry if this is not the right place for this question. I couldn't find the right forum!!! How can I dynamically embed data from SQL Server into a word document I have a Contract of Sale document in word format that I need to automate so that details from the database (e.g. sale date, client name, contact details etc) are dynamically added to this word document. I haven¡¯t done anything lik
  • minumum cell width is limited by margins and setting margins to 0 does not seem work properly from VS 2005.
    by Thwack
    7 Replies
    Last post by Cindy Meister
      • Hi, From word 2003 If i create a table and set the cell margins to 0 I can make the width of a column as small as I want. (the minumum is otherwise limited by the cell margins) However I have an issue doing the same thing from visual studio 2005. Using Microsoft.office.interop I set the LeftPadding and RightPadding table properties to 0.0 and this seems to work fine. However. It seems
  • How to know the current hight of the cell in a Microsoft document via c# program.
    by vincent90152900
    3 Replies
    Last post by vincent90152900
      • I use Word Application object to operate a Microsoft Word file. I would like to know the current the hight of a specific cell in the table. When the HeightRule is wdRowHeighAuto and the Height propertys always be 9999999.0. How to do get the current Height of the cell Code Snippet // Declaring the object variables we will need later object varFileName
  • Excel ListObject issue
    by Ben Van Mulders
    3 Replies
    Last post by Dennis Wallentin
      • Hi, My problem is the following : I've added a ListObject to an Excel-sheet. It has no rows to start with. Let's say i'm pressing a button and a certain number of rows are added. So far so good, the cells are being filled correctly. Now when I press the button again, I'd like the ListObject to "refresh" i.e. all rows should be deleted, and new ones added. (The number of rows to be added
  • Copy-paste office documents via clipboard
    by braz
    4 Replies
    Last post by braz
      • Hello! I need to copy paste office documents via clipboard. I wrote next code: public void InsertDocument( object mDocument, string documentFileName) { if (mDocument!= null ) { FileStream fileStream = new FileStream(documentFileName,FileMode.Open); byte [] file = new byte [( int )fileStream.Length]; fileStream.Read(file,0,( int )fileStream.Length);
  • Excel Add-In
    by Aleks
    7 Replies
    Last post by Badrul
      • Hi all, First, I'm new in VSTO developpement so sorry if my questions are ... stupid. I'm developping an Add-In for Excel 2007 and discover that every rule I code in C# (for example) will not be applied if the sheet is opened by an Excel that does not have my Add-in Install. My application is for someone (Mr A) that need to get some data from a DataBase, then give it to someon
  • Will C#.Net Excel Addins replace C API Addins?
    by dsamperi
    6 Replies
    Last post by dsamperi
      • Using the C API to develop Excel Addins results in fast code but at the expense of working at a very low-level with a highly non-intuitive and non-object oriented framework. The VSTO tools and VS 2008 Beta suggest that a better solution is on the way, but at the current time it is not very well documented, it seems to me. The solution offered in VSTO is the Automation Addin. This t
  • Saving excel as an image file
    by Mablao
    6 Replies
    Last post by Geoff Darst - MSFT
      • Anyone knows how can I save an Excel file to a image file (.gif or .jpg ) using VSTO Note that, I want to export the entire worksheet (there are no charts in it). Thanks.
  • VSTO 2005 with Visual Studio Pro 2003 and Visual Studio Pro 2005
    by youngloc
    9 Replies
    Last post by youngloc
      • I have been running the following for a while before I installed VSTO 2005 recently: Office Professional 2003 SP2 Visual Studio Professional 2003 Visual Studio Professional 2005 SP1 I have just installed VSTO 2005, but I cannot find its project templates in Visual Studio 2005's menu: File > New > Project. In Visual Studio 2005's Help > About..., I can see ' Micr