-
- Excel bound/cached data problem
by karfast
- 3 Replies
- Last post
by karfast
- Hi, I tried out the walkthrough on creating a Master Detail Cached dataset in Excel. I followed each step precisely.
ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vstcore/html/419f4e07-c67f-4fc9-973a-bc794f349ac3.htm
Simple enough, and the data displays correctly.
Problem is that I cannot get the data to sync with the DB. I worked within DevEnv (VS2005 Team, SP1, VSTO
-
- How to prevent executing macro from another workbook in Excel.
by iliaroot
- 1 Replies
- Last post
by Douglas H. Troy
- Hello all,
I would like to restrict my workbook's macro execution.
So I do not want somebody to be able to run the code like this:
Application.Run("MyWorkbook.xls!runMyProcedure", 1000, False, False, False)
How to implement this
Thanks in advance,
Ilia
-
- Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2)
by Bill Coan
- 9 Replies
- Last post
by Bill Coan
- Has anyone tried to follow along with the new article on "Deploying Visual Studio 2005 Tools for Office Second Edition Solutions Using Windows Installer (Part 1 of 2)"
The article is here:
url:http://msdn2.microsoft.com/en-us/library/bb332051.aspx
About half-way through Part 1, the following instructions appear, leaving me perplexed:
Preparing the Office Comp
-
- No web item templates, errors installing Outlook add-in MyBlogs (no projecttype dir), no ASP.NET
by Alek Kirstein
- 3 Replies
- Last post
by Alek Kirstein
- Hi,
Thanks for your time. I am a DBA/Database and BI developer. I do heavy SQL, tons of Office development, desktop VB apps. I'm now getting on track with ASP.NET, Reporting Services, and software deployments over the web and local install packages. Mainly coupling SQL BI and performance monitoring through client web interfaces. So cool.
My issue is I don't think and maybe don't know what te
-
- Missing Office Project Templates
by Rocco Mastrangelo
- 6 Replies
- Last post
by Malleswar
- Hi,
I have searched this forum and I am still not sure that I have an answer.
I have installed the following:
Visual Studio 2005 Professional
Office 2007 Professional
Visual Studio Tools for Office SE (second edition)
These are all released bits. I was under the impression that after installing VSTO SE, that I would be able to create Excel Workbook projects. In other words, selec
-
- How to recover information of the user according to his click ?
by Monico
- 8 Replies
- Last post
by Monico
- Hello, I have any questions about VSTO for Outlook 2007. I success to create a button in my CommandBar (Standard) but if I want this button in my Appointment for my Calendar, it doesn't exist. So my question is : is it possible to have my button when I create an appointment And my second question will be : how it's possible to know what the user is clicking. For example, he click on an email : ho
-
- word instacnce is not opening document in it
by Sidi
- 5 Replies
- Last post
by Geoff Darst - MSFT
- Hi,
I am creating instance of word in asp.net by using following code
Public WithEvents wrdApp As Word.Application
wrdApp = New Word.Application
......
when code reaches to
' Add a new document.
wrdDoc = wrdApp.Documents.Open(Server.MapPath(strSrcFileName))
code halts. It is creating instance of word but then nothing happens please tell me is this an issue of rig
-
- VSTO 2005 Excel C#
by Rick_HRO
- 1 Replies
- Last post
by Dennis Wallentin
- I authored a simple application written using VSTO 2005 Selecting Excel.Workbook as a project template. Originally I used the Action pane to solicit user input using a user control containing 3 buttons and two list boxes. The list boxes were populated using XMLDoc features and the data returned is also from an XML file.
The application runs perfectly when installed on any systems running MS
-
- Control like "Type a question for help"
by Alver
- 2 Replies
- Last post
by Alver
- How to make a ComboBox Command Bar control like "Type a question for help" in all Office application I create my own CommandBarComboBox in Outlook 2003, and set up a handler for Change event. I want to clear input text if users press Tab key for example, the sismilar behavior as "Help" combobox. But I can't do this. I don't find any way to catch this action. Change event does
-
- Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook._Application'
by Kulvinder
- 7 Replies
- Last post
by Andrew Cherry [MSFT]
- Hi,
I am using Outlook 2003 professional and getting the "MAPI" Namespace reference using :
Microsoft.Office.Tools.Outlook.Application.GetNamespace(String Type)
The exception which i am getting is :
Unable to cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Outlook._Application'. This operation failed because the
-
- Ribbon callbacks signatures and icons
by davide_c
- 1 Replies
- Last post
by Cindy Meister
- Hi,
Does anybody know where to find the signatures of the Ribbon callback methods
I think that documentation still lacks a huge amount of things. Specifically, I'm now looking for the onAction and getPressed methods of the checkBox object. (I can imagine that onAction needs a Office.IRibbonControl parameter but it also need something else.) The document at http://msdn2.microsoft.com/en-us/li
-
- Using the proofing tools with an API
by nobody1234z
- 1 Replies
- Last post
by Cindy Meister
- Is the functionality of the Microsoft Proofing Tools exposed with an API For example, I would like in a program in C or in C# to check grammatically a sentence using the microsoft grammar checker. Is this possible
-
- API or Plug in to add options to the Outlook
by Malleswar
- 5 Replies
- Last post
by Sue Mosher - Outlook MVP
- Hi, Can any one please tell me API or plugin or component to add the options to outlook which is compatible for 0utlook2003 and Outlook2000. Thanks in Advance,
-
- Excel Applicaion breaks after 13107 iterations ... Please Help
by zoddiax
- 7 Replies
- Last post
by zoddiax
- Hello
I have an Windows Forms Application which transfers data from one excel workbook to 5 different worksheets in another excel workbook for 15000 times but my application breaks after 13107 iterations .
Yesterday after doing some random calculation I came to the conclusion that there must be some kind of overflow
13107 * 5 (# of worksheets) = 65535
65535 + 1 = 2 to the p
-
- Passing a double array from vba to an Automation C# addin
by davidmac100
- 3 Replies
- Last post
by Cindy Meister
- windows XP Vis studio 2003 ============== newbie to creating automated c# addins, and have been able to pass a range object, object, string, double etc through from vba to c# class, however passing a double array is proving difficult. i first tried passing by ref both double[] AND object and then casting; VBA: Application.Run "bump", Array(1, 2, 3), 0.25 C# public double bump(ref obj
-
- VSTO DOWNLOAD n INSTALLATION
by suneelpotluri
- 2 Replies
- Last post
by suneelpotluri
- Where can i get the free download link to VSTO Can anynbody pls tell me how to install/PIA and the installation process to make work with office 2003 and VSTO IT's urgent.. Regards Sunil
-
- How to add a button inside an outlook add-in?
by perpetual_dream
- 3 Replies
- Last post
by Robert Green
- Hello,
I am trying to create an outlook add-in that allows the user to select the place to save the mail item at. My problem in the first place that I can't add a button to Microsoft outlook
Private _cbBar As Office.CommandBar
Private WithEvents _cbButton As Office.CommandBarButton ' CommandBarButton to show search folder form
Private Sub ThisAddIn_Startup( ByVal sender As
-
- VSTO - Click/Select Event Handler for Context Menu Item
by Anonymous563083
- 3 Replies
- Last post
by Douglas H. Troy
- I have added the following script to add a context menu item on the right-click of word document.
// Add these Form level declaration
private Microsoft.Office.Core. CommandBar Cbar; private Microsoft.Office.Core. CommandBarControl CmdBarNewCtrl;
// Add this code in the openFileDialog1_FileOk event handler after this code // doc = WordApp.Documents.Open(ref fileName, ref missing, r
-
- How to get the images from a word document
by Kesava
- 9 Replies
- Last post
by Douglas H. Troy
- Hi all
I am using VS2005 and Microsoft.Interop.word assembly of word2003.How to read the word document which contains paragraphs and images.Can any one provide a sample code to accomplish my requirement.
regards
keshav
-
- Which "Event Handler-adding" code is more appropriate for my application add-in?
by Mike Smith-Lonergan
- 2 Replies
- Last post
by Mike Smith-Lonergan
- I've been puzzled by something for a while...every time I go looking for good source to double-check that the CommandBar and buttons I'm adding to one of the Office apps, I seem to come across one or more variants of the two main approaches here.
Approach 1 (VB):
Private WithEvents uiButton As Microsoft.Office.Core.CommandBarButton
Approach 2 (C#):
uiButton.Click
-
- Excel Visual Studio Design Time Adapter Add-in
by Hbomb624
- 11 Replies
- Last post
by robotjesus
- After installing VSTO and VSTO SE, when I try to create a new Excel VSTO App I get this message:
"Project cannot be created because the application add-in is not working correctly and might jave been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or About Microsoft Office Excel, and then click Disabled Items.
-
- Tex to Word 2003 Equation
by surendrasyam
- 2 Replies
- Last post
by surendrasyam
- I need to programatically create word documents from .net by pumping information from the database. I have a field with tex-math information. I want to convert this field to a editable equation type in word 2003.
Can any one suggest me a method to accomplish this. Thank you.
-
- Replacing entire folder view with custom user control. (Outlook 2007)
by DavidR_910
- 4 Replies
- Last post
by DavidR_910
- In Outlook 2007, I'm trying to replace an entire folder pane / folder view when you select a folder to have a custom user control instead. The closest I can get is using a custom task pane, however, that is limited to how big it can be. I keep running into an advertisement from add-in-express which their product is able to do, but I was hoping for a less expensive solution to this. Replacing a web
-
- Parsing a word document
by Subhash Garg
- 1 Replies
- Last post
by Maarten van Stam
- Hi,
I am trying to automate word by writing an add-in. Once the document is written, I need to parse it. The document can contain text, images, ole objects and tables. I know how to open document, iterate paragraphs, iterate tables, images etc. When I iterate using paragraph collection, each line in table is returned as a paragraph.
I need a sample something like this ;
Foreac
-
- Problem detecting selected cells in Excel
by Lisa562594
- 2 Replies
- Last post
by Mohit Gupta - MSFT
- I have a VSTO app using an Excel template. I select four cells (G12, H14, H20 and J15, in this example), and run this code:
For i As Integer = 0 To BudgetUpdate.Globals.shBudgetUpdate.Application.Selection.Cells.Count - 1 MsgBox(BudgetUpdate.Globals.shBudgetUpdate.Application.Selection.Cells(i).Address) Next
I get four MsgBox results popping up, reading, in order: $G$11, $G$12, $G$1