-
- ComboBox on an Outlook PropertyPage doesn't seem to get DrawItem events
by BenDowling
- 11 Replies
- Last post
by Ji Zhou ¨C MSFT
- I want to display several ComboBoxes on an Outlook PropertyPage. I want the ComboBoxes to display icons and text. I've tried two approaches to this: Setting the draw mode of a standard ComboBox to DrawMode.OwnerDrawFixed and then setting a DrawItem callback. However the callback never gets called. I then tried extending the standard ComboBox class that sets the draw mode in the constructor and ov
-
- Problem with Adding MS Office 11.0 Object Library to Project
by Nima Amin
- 5 Replies
- Last post
by Dennis Wallentin
- Hi, I add Microsoft Office 11.0 Object Library to my project's references. But I cannot use these codes do define my office object: (VS2005 does not recognize them and says, "'Excel.Application' is not defined.") Dim xlApp As Excel.Application Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet What should I do Thanks
-
- Fuzzy text in a label control
by Arthlan
- 6 Replies
- Last post
by Arthlan
- Hi,
I've added some controls to the top of a sheet in an Excel file. The problem I'm having is that the text on, say a label, is blurry or fuzzy. It almost looks like when smoothing is being applied but actually makes it worse. I've tried various fonts and sizes and that doesn't matter. The rest of the text on the sheet looks fine. Has anyone seen this before, and hopefully knows what's happeni
-
- Access Runtime
by AnneF
- 5 Replies
- Last post
by Cindy Meister
- I have to deploy an Access database using a runtime version. I have been told that it has to be done now using VS 2005 Team Edition Developer instead of Access Developer Extension.
I have created the setup with VS 2005 using an access database (mde file), but don't know how to create and add the runtime version.
I have looked for help, but cannot find anything on the subject, thank you if yo
-
- automating cell if negative value is found
by restyong
- 1 Replies
- Last post
by Dennis Wallentin
- pls. help i had a text value in row A1 to A5 and number value in row B1 to B5 that represent A1 to A5, now my problem if cell B1 to B5 result to negative value how can i transfer the NEGATIVE number value only to populate to C row as well as the text value to D row any help is appreciated
-
- Accessing Excel ComboBox values programmatically
by kroyce
- 8 Replies
- Last post
by kroyce
- All,
I have created an Excel add-in that loads information from Microsoft Project Data Server into a spreadsheet. For each row of data added to spreadsheet, I add a combobox that is populated with several options to choose from (there is a different default value for each combobox). I use the following code snippet to add the comboboxes to my spreadsheet:
Microsoft.Office.Tools.Excel.Control
-
- Reading Excel From C#
by DOSST
- 14 Replies
- Last post
by bad neighbor
- You can read data from Excel using the JET OLEDB provider. See the URL below
for the necessary connection string, and a link to a KB article with further
information ...
http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMicrosoftJetExcel
--
Brendan Reynolds
wrote in message
news:9226766e-a1d5-400c-8d3c-8ffc566bec50@discussions.microsoft.com...
> Hi
>
> Can anyo
-
- Dynamically creating Excel Sheets and Charts from .NET 2.0 App
by udooz
- 2 Replies
- Last post
by udooz
- Hi,
We are developing a reporting application for our company internal purpose. For this, the application fetches various types of data from different data sources and accumulate these into its local data source.
Based on the data, it has to generate report for various formats for selected periods. The report would be prepared based on the number of products selected by the user.
-
- Trying to create a user using VSTO...
by Emilio_melo_2003
- 2 Replies
- Last post
by Emilio_melo_2003
- Hi guys,
I'm currently working on a project on the company I'm outsourced to, to automate user account creation on the Active Directory. The first version of the software is working pretty good, it's a Windows Form with all the fields necessary for the user creation.
The second version, however, intend to be an Infopath form where the manager fills in and the account is automatically cre
-
- Databinding in Excel
by Stokh
- 5 Replies
- Last post
by Mathieu Hetu
- Hi!
I have an VSTO Excel project. I added a workbook that has 3 sheets in it and has all the formulas and functions built into the worksheets. It needs to stay there! I had a datasource and try to bind to a listobject or named ranges or anything and it over writes my functions etc that are already in the sheets.
How can I databind using code to get the full results returned to the works
-
- hebrew date in outlook
by amosexy
- 5 Replies
- Last post
by Ji Zhou ¨C MSFT
- hey
i try to get a hebrew daye from the putlook object and i dont know the function
how can i get with vb the hebrew date and the holiday from outlook
tnx
-
- Outlook 2007 - Selected Text
by Uli-B
- 20 Replies
- Last post
by Uli-B
- Hi, i am currently writing an add in for Outlook 2007 in C# and i need to get the Text selected in the current e-mail. I already looked for a detailed description, how to do this, but did not find anything. Can anybody help me kind regards Uli
-
- How to Import a .msg and .pst file into Outlook 2007 with C# code?
by TestCaseTim
- 6 Replies
- Last post
by TestCaseTim
- I need to import .msg and .pst containers into Outlook 2007 using c#. I am aware of the CreateFromTemplate method, but this alters the message by saving it as an unsent email. I want to import the message items into Outlook without modifying them, just like if I imported them manually through the UI. I don't know Extended MAPI and was trying to avoid using Redemption if possible. If these are my o
-
- Automating C# and Microsoft Access
by Swanysto
- 5 Replies
- Last post
by nitewulf
- When I searched, I could not find an answer, so I am creating my own. I am doing a project for school. I have to use Microsoft Access and Visual C#. I do not have any experience in Visual C#, but I am getting the hang of it. I am creating a front end for a church database. Everything is working except for the reports that I must create. I was told the easiest way to do the reports is by automation
-
- Need Help Declaring Array(s) for Workbooks.OpenText(Fieldinfo)
by NCGordon
- 9 Replies
- Last post
by Dennis Wallentin
- I wish to open ".csv" files using a VSTO Excel 2003 template. All the files have 4 columns each, and all should be set as "XlColumnDataType. xlTextFormat .
I'm stumbling with the FieldInfo parameter of the Workbooks.OpenText method. The documentation says:
FieldInfo: Optional XlColumnDataType. An array containing parse information for individual columns of data. Th
-
- VB.NET - outlook security alert - default profile
by Mario vde
- 1 Replies
- Last post
by Sue Mosher - Outlook MVP
- Greetings! I am currently finishing up my syncronisationprogram between outlook 2003 and ms Access. The meaning of this program is to backup and restore appointments from the calendar. Now, everything works just fine, accept for one thing: whenevery I want to read the body of an appointment I get the alert in outlook "a program is trying to access....." and then I have to choose 1 2 5 ...minutes t
-
- How to create/insert a chart in Word document using VSTO?
by Charlotte Jensen
- 2 Replies
- Last post
by Cindy Meister
- Hello,
how can I create a chart in a Word document using VSTO I haven't been able to figure out how to do this task.
I have been thinking about creating a hidden excel sheet, copying the data from source into the sheet and generating a chart whereafter I will copy the chart into the Word document and kill the excel sheet again.
This however seems very troublesome - How is the best method
-
- Why does an Excel Automation add-in load on Excel start up (and not on-demand as expected)
by Pete_J
- 4 Replies
- Last post
by Pete_J
- Hi,
We have created an automation add-in for adding hotkeys to Excel 2007.
On two developers machines/profiles, the automation add-in is invoked on Excel start up, and on the third, the add-in starts up as expected - on demand when our function is called [i.e. when a shortcut/hotkey combination is pressed].
So....
1) What could be causing the Automation add-in to load on Ex
-
- Filename and params
by lrjanzen
- 1 Replies
- Last post
by Geoff Darst - MSFT
- I know I've seen this somewhere in the forums but can't get the right seaarch param for it. What is the property to read the file name of the current workbook in excel 2003 via VSTO MyWorkbook.FIlename or something like that.
Thanks Lonnie
-
- PropertyAccessor.GetProperty Method (C#)
by EagleWizard
- 11 Replies
- Last post
by EagleWizard
- Code Snippet
Outlook. PropertyAccessor pa;
pa = m_olMail.PropertyAccessor;
string propname = "http://schemas.microsoft.com/mapi/proptag/0x0030001E" ;
string sprop = pa.GetProperty(propname).ToString();
I'm using this code to access a property of a mail object in Microsoft Outlook 2007, but I always get a DISP_E_TYPEMISMATCH error
"Message "Typ
-
- Converting Interoped Code to Managed Code
by PaulNations
- 9 Replies
- Last post
by Sue Mosher - Outlook MVP
- I have an old VB6 program that uses Word automation to fill in a bunch of bookmarks with text from the database. I urgently need to rewrite it, as it only works on a few relic machines now. When I started the conversion I see that the Bookmark.Range object has been deleted from the .NET object model. I'm trying to download the new definition from http://www.microsoft.com/downloads/details.aspx fam
-
- Custom Deployment .Application
by Niklas
- 2 Replies
- Last post
by Niklas
- I¡¯m trying to create an MSBuild script to build an Deploy an Excel document application.
The only remaining mystery is how to create the .Application file
Does anyone have an example how to publish an VSTO application outside the VSIDE
-
- XML Tags in VSTO documents disappear
by pnp
- 7 Replies
- Last post
by pnp
- Hi all
I have a somehow weird problem. We have implemented at Word VSTO Solution. In this word document we use a lot of XML tags to locate data and be able to extract it from the document, and save the document as XML and send this to a reporting tool.
All this works as expected. The problem appears when a person from our company HQ sends the Word document to one of our subsidiaries.
-
- vb dll problem in c# vsto project
by xishan shigri
- 5 Replies
- Last post
by OmegaMan
- i am trying to use a dll developed in vb via my c# project (an add in for outlook using vsto 2005) and it rungs successfully runs on my machine but when i deploy it on customer's PC it wouldn't work. Problem is at that point where i am instatiation a class of vb dll and accessing its function . when i remove these two line of code it works but i have to use that vb dll can anybody out there h
-
- HTML in Outlook meeting body
by Justin Barnes
- 9 Replies
- Last post
by Sue Mosher - Outlook MVP
- First question: If I use the outlook object model included with VS2005, is it only going to work with clients that have office 2003 installed I'm using my code to create an appointment via a web app, and can't rely on any specific version installed.
I found another way to create the file, so that isn't too much of an issue if so. But my second quesiton is:
I'd like to create a link in the b