Visual Studio Tools for Office Forum

How to access a plaintextcontentcontrol in an document from an application addin?

Tue, 29 Sep 2009 17:59:46 Z

Hi,

i need to develop under vs 2008 a word 2007 template with some fields and bookmarks. I have now created a Word 2007 AddIn Project and a Word 2007 Template Project.

In the Word 2007 Addin Project i did:

1. I added a Ribbon with a Button

2. Added a Form (InputForm)

3. The Button on the Ribbon open the Form

In the Word 2007 Template Project i did:

1. I added two fileds (bookmarks) in my document

Now i want to open my template (create a new document out of it) and click on my button in the ribbon.

This opens my form and i want to insert some text on button click at the bookmarks with i had inserted before in my word template.

I only need to know, how i can use the bookmark fields from an application based addin form.

Can someone help please?

thank you

yavuz

Excel Ribbon for 2007 and Menu for 2003

Mon, 23 Nov 2009 20:40:06 Z

I have an Excel Office application that was built on Office 2003 - with its own Menubars, etc.

I would like to use the same application in Office 2007 - but instead of keeping the Menubars (and having it show up in the Add-Ins tab) , build a new Ribbon for it

I was wondering if it is possible to have my Code-behind code determine the Office version then either build out the Menubar (if 2003) or Ribbon (if 2007).

I have successfully built out an Office 2007 Excel app with its own Ribbon - so I am familiar with how to perform this task.

Is this even possible considering the different DLLs that may be required to accomplish this?

Properties missing from my wdDialogFilePrintSetup object?

Wed, 25 Nov 2009 15:31:57 Z

Hello!

I am trying to automate printing from Word 2007 through a VSTO customization that I have developed.

When users hit Ctrl+P i display a custom print form with "friendly names" for all our network printers, and information about trays and what kind of paper is located in these.

The problem is when the users hit my "Change printer" button. This brings up another form, which lists all our printers (from an XML-file). When they select one and clicks "Ok" I want to set the current printer in Word to that partucular printer.

I have found example code that does exacly what I want:

strDeviceName = m_Printers(PrinterInfo.DeviceName, intIndex)
        With Dialogs(wdDialogFilePrintSetup)
           .Printer = strDeviceName
           .DoNotSetAsSysDefault = True
           .Execute
        End With

My case is that I am using C# code in my project, and there I cannot access these properties:

.Printer

.DoNotSetAsSysDefault

They simply don't exist in my dialog-object that I create like so:

Word.Dialog dlg = Globals.ThisAddIn.Application.Dialogs[WdWordDialog.wdDialogFilePrintSetup];

I have tried setting the Application.ActivePrinter instead, but that has two major drawbacks;

1. it is veeeeery slow to set a network printer this way. The application hangs for up to 30 seconds while it is polling the network or whatever...

2. it also changes the users default printer. setting it back again after printing will trigger another hang as in 1...

So, now I am stuck...

Could anyone please advice?

Thanks!

Changing the anchor of a shape

Thu, 19 Nov 2009 23:39:04 Z

Hi,

I am trying to make a plug in for Microsoft Word 2007, what I need to be able to do is change the position of a shapes anchor to a specific paragraph so that when the paragraph is moved that the shape maintains its correct position in relation to the paragraph, any ideas on how to do this? I am working with C# and Visual Studio 2008. Thanks.

Can a MS COM add-in (word for example) send messages to C# application?

Thu, 19 Nov 2009 11:32:18 Z

I've built a word com add-in and everytime when the document closes: a dialog pop up saying what document it is. Is there a way that instead of that, have the com send messages to my C# application

need help iterating through empty Excel cells

Wed, 25 Nov 2009 20:49:22 Z

I'm new to Office development, so thanks in advance.

I'm just wanting to start at a specific cell, and then go done a column applying a method to each cell that is not empty.

how do i go about doing this?

Thanks again.

VSTO:Excel:Actionpane controls won't populate from sql table

Mon, 23 Nov 2009 03:20:32 Z

I have a custom actionpane in Excel 2007. I want to have a checked listbox that is populated from a SQL table.
The data source is configured and I see the tables and columns that I want to choose from.
I drag a column over to the action pane and create a checked list box.
When I run it under debug, the control is not populated. Nothing that I have tried in the last few hours has worked. My static collection listboxes show up fine.
If I drag the table icon into one of the spreadsheets, it's populated, so I know my connection is good.

Cannot figure out this COMException for add-in for outlook 2003

Mon, 23 Nov 2009 16:18:47 Z

I'm getting an odd outlook.attachment.comexception that seems to be occurring when certain users attempt to save attachments that are actually linked images (eg, the email is an HTML email and the attachment is actually an <IMG/> with src="http://someexternalserver"). We have limited internet access for most people here, so I am assuming that the limitation is causing the issue, but since I cannot find more information on the error, i have no way of actually knowing this.

Here is the exception:

System.Runtime.InteropServices.COMException (0xBBC04005): Cannot save the attachment.  Can't create file: item_minus.gif.  

Right-click the folder you want to create the file in, and then click Properties on the shortcut menu to check your permissions for the folder.

  at Microsoft.Office.Interop.Outlook.Attachment.SaveAsFile(String Path)

The file is being saved into a subdirectory their "My Documents" directory and they have full control over that directory. I also checked to make sure the file didn't exist before attempting to save. I haven't been able to find anything on the error code 0xBBC04005. If the problem does seem to be that it cannot reach the "attachment" from the external web server, is there any way that I can know that it is linked from an Outlook.Attachment object? Does anybody have any more info on that error code?

The add in runs on Outlook 2003.

Any help appreciated.

how to disable security pop up while reading OUTLOOK public calendar

Tue, 17 Nov 2009 19:52:36 Z

I am writing a code to read my public calendar and write to file, and i want this to be scheduled. But everytime i try to read the item it pops up a security dialog saying "a program is trying to access email addresses you have stored in outlook. do you want to allow this". I want to get rid of this pop up. Please help. i have attached my code below

            Outlook.Application objOutlook = new Microsoft.Office.Interop.Outlook.Application();
            Outlook.NameSpace objNS = objOutlook.GetNamespace("MAPI");
            Outlook.Folders oFolders = objNS.Folders;
            Outlook.MAPIFolder oPublicFolder = oFolders["Public Folders"];
            oFolders = oPublicFolder.Folders;
            Outlook.MAPIFolder rcFolder = oFolders["CALENDAR"];

            Outlook.Items rcItems = calFolder.Items;

            TextWriter tw = new StreamWriter(c:\test.txt);
            int irc = 1;
            while (irc <= rcItems.Count)
            {
                try
                {
                    AppointmentItem airc = rcItems[irc] as AppointmentItem;

                    if (airc != null)
                    {
                        tw.WriteLine(ConvertToString(airc.Start) + "|" + ConvertToString(airc.End) + "|" +
                            ConvertToString(airc.Subject) + "|" + ConvertToString(airc.Location) + "|" +
                            ConvertToString(airc.Categories) + "|" +
                            ConvertToString(airc.Body) + "|" + ConvertToString(airc.RequiredAttendees) + "|" +
                            ConvertToString(airc.OptionalAttendees) + "|");
                    }
                }
                catch { }
                irc++;
            }
            tw.Close();

Please help as it is really urgent.

Control of Value2 setter

Wed, 25 Nov 2009 10:37:59 Z

Excel 2007 and VSTO 3 SP1. I some range object and two dimensional array with indexes starting with 1, specially made for this thing. Then I assign array to range:

object[,] newData = ...
Range r = ....
r.Value2 = newData;

newData is fine every time as I inspect it in the debugger, r is not null. However, setting Value2 works mostly, but may fail. And if it fails, the whole method it is called from is interupted. No try...catch can really catch this fail, perhaps it is COM exception. So, what to do? I dont care why it fails, I just want to know if setting was successfull or not and continue method execution

[Excel Add-In][C#] - Output data to Cell

Wed, 25 Nov 2009 04:28:13 Z

Hi

Should be a really simple answer, but endless amounts of searching has turned up nothing.

I'm making an Excel Add-In (in C#), and I want to "export" data from a custom Form into a specific cell in the current spreadsheet. Thats it, pretty simple - just can't figure it out...

Thanks.

VSTO 2010 and .NET framework versions

Mon, 23 Nov 2009 08:23:18 Z

Hello,

I am currently using Visual Stusio 2010 Beta 2 to try a port of an Office solution written with Visual Studio 2008 and VSTO 3.
My office solution is composed of two add-ins to Word and Excel 2007.
These add-ins reference assemblies that are not yet built on .NET 4.0. I have thus defined the target framework of my VSTO project to .NET 3.5 Client . However, the VSTO 2010 runtime does not load the add-in if it does not target the .NET framework 4.0. This all makes sense, but I would like a confirmation of the following:

- VSTO 3.0 based solutions cannot be loaded in Office 2010
- When using VSTO 2010, one has to recompile all required assemblies using Visual Studio 2010 / .NET 4.0

Corollary: Office 2010 applications can only run customizations built on .NET 4.0

Thanks a lot to anyone who can clarify this.

--
Cyril

Catching when Outlook goes in offline mode with exchange

Mon, 23 Nov 2009 11:46:37 Z

Hi All,

I have a VSTO add-in for Outlook 2003 and 2007, developed in C#. I can detect if Outlook is in offline / online mode at any instant.

Is there any event that is fired when Outlook goes to offline mode / returns to online more (either by user command or by any way) ?

In that way I will be able to notify my plug-in to hang / pause processing if Outlook goes offline.

Best Regards,

Nadeem

Outlook Folder Home Pages

Wed, 18 Nov 2009 14:56:13 Z

Does anyone know whether using WebViewUrl will maintain cookies during a session of Outlook. For example, I set the WebViewURL for a folder to an internet site where the user authenticates. The user then can navigate the site within Outlook. If the user clicks on another folder and navigates back to the folder that has the WebViewUrl set it will ask them to login in again. I checked the cookie by doing alert(document.cookie) and it's blank. So my guess that it will not maintain the cookie.

I notice Microsoft Dynamic CRM does this successfully but I'm not sure whether they are using cookies.

microsoft.office.interop.outlook.dll CSLID error

Tue, 24 Nov 2009 15:31:56 Z

I all, maybe by the title you may figured out what is my problem. the real deal is, that I wrote an XBAP application to retrive from Outlook your contact list. The cool thing is that works in some machines with Vista and 7, even in a old XP. Sweet

But, in some machines I'm getting this error: Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80070005.

I also try to search some workarrounds for this, and I used some advices from anothers that has similar issues. The real strange thing is the facto that not work in all machines...

any adicional ideas?

thanks

Outlook 2010 Add-In issue: Customization could not be loaded because the application domain could not be created.

Mon, 23 Nov 2009 14:57:57 Z

Hi all,

I hit the wall while trying to start my add-in inside the Outlook 2010 beta on my test x64 machine.
Add-in fails to load and reports the following error: Customization could not be loaded because the application domain could not be created.

The very same add-in works on a x86 machines!

Please help,
Saša

Reported error:

Log Name:      Application
Source:        VSTO 4.0
Date:          11/23/2009 2:44:17 PM
Event ID:      4096
Task Category: None
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      w7TCOForGregg
Description:
Customization URI: file:///C:/Program Files (x86)/Company/AddInName for Outlook/Company.AddInName.Outlook.vsto
Exception: Customization could not be loaded because the application domain could not be created.

************** Exception Text **************
Microsoft.VisualStudio.Tools.Applications.Runtime.CannotCreateCustomizationDomainException: Customization could not be loaded because the application domain could not be created. ---> System.BadImageFormatException: Could not load file or assembly 'file:///C:\Program Files (x86)\Company\AddInName for Outlook\Company.AddInName.Outlook.dll' or one of its dependencies. An attempt was made to load a program with an incorrect format.
File name: 'file:///C:\Program Files (x86)\Company\AddInName for Outlook\Company.AddInName.Outlook.dll'
   at System.Reflection.Assembly._nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection)
   at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection)
   at System.Reflection.Assembly.LoadFrom(String assemblyFile)
   at System.AddIn.Hosting.ActivationWorker.Activate()
   at System.AddIn.Hosting.AddInActivator.ActivateInAppDomain[T](AddInToken pipeline, AppDomain domain, AddInControllerImpl controller, Boolean weOwn)
   at System.AddIn.Hosting.AddInActivator.Activate[T](AddInToken token, AddInEnvironment environment)
   at System.AddIn.Hosting.AddInToken.Activate[T](AddInEnvironment environment)
   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, AddInToken addInToken, String assemblyName, String[] entryPoints)
   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.DomainInitializer.StartAddIn(IntPtr hostServiceProvider, AddInToken addInToken, String assemblyName, String[] entryPoints)
   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.LoadMafPipeline(AppDomain newDomain, IntPtr hostServiceProvider, AddInInformation info, EntryPoints requestedEntryPoints, OfficeApp officeApplication, OfficeVersion officeVersion, IntPtr& executor)
   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator.CreateCustomizationDomainInternal(String solutionLocation, String manifestName, String documentName, Boolean showUIDuringDeployment, IntPtr hostServiceProvider, IntPtr& executor)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

--- End of inner exception stack trace ---

************** Loaded Assemblies **************
mscorlib
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework64/v2.0.50727/mscorlib.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Office.Runtime.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.20825.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Office.Runtime.v10.0.dll
----------------------------------------
System
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Core/3.5.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.AddIn
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn/3.5.0.0__b77a5c561934e089/System.AddIn.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.20825.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Hosting.v10.0.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.20825.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v10.0.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0
    Assembly Version: 10.0.0.0
    Win32 Version: 10.0.20825.1
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0/10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.ServerDocument.v10.0.dll
----------------------------------------
Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0
    Assembly Version: 9.0.0.0
    Win32 Version: 9.0.30729.4130
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0/9.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Tools.Applications.Runtime.v9.0.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Deployment
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Deployment/2.0.0.0__b03f5f7f11d50a3a/System.Deployment.dll
----------------------------------------
System.Configuration
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Security
    Assembly Version: 2.0.0.0
    Win32 Version: 2.0.50727.4927 (NetFXspW7.050727-4900)
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Security/2.0.0.0__b03f5f7f11d50a3a/System.Security.dll
----------------------------------------
System.Xml.Linq
    Assembly Version: 3.5.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.Xml.Linq/3.5.0.0__b77a5c561934e089/System.Xml.Linq.dll
----------------------------------------
System.AddIn.Contract
    Assembly Version: 2.0.0.0
    Win32 Version: 3.5.30729.4926 built by: NetFXw7
    CodeBase: file:///C:/Windows/assembly/GAC_MSIL/System.AddIn.Contract/2.0.0.0__b03f5f7f11d50a3a/System.AddIn.Contract.dll
----------------------------------------

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
    <Provider Name="VSTO 4.0" />
    <EventID Qualifiers="49154">4096</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-23T13:44:17.000000000Z" />
    <EventRecordID>2778</EventRecordID>
    <Channel>Application</Channel>
    <Computer>w7TCOForGregg</Computer>
    <Security />
</System>
<EventData>
    <Data>Customization URI: file:///C:/Program Files (x86)/Company/AddInName for Outlook/Company.AddInName.Outlook.vsto
Exception: Customization could not be loaded because the application domain could not be created.

--- End of inner exception stack trace ---

</Data>
</EventData>
</Event>

Sasa Tomicic <--> MCTS WSS 3.0, MCPD EAD... www.teamcompanion.com

how to drag and drop the date from the excel custom pane to excel active cell or work sheet in vsto

Tue, 24 Nov 2009 12:38:18 Z

Hi,

I have a application like creating a custom pane in the excel 2007 using vsto. I added a custom pane i.e., user control...it is having some data...i should be able to drag and drop the selected item from the user control(i.e., custom pane) to excel active sheet active cell or active worksheet where i droped

pls reply with solution

It is very immediate req...pls help me

Auto complete AutoText entries in Word 2007

Wed, 25 Nov 2009 02:58:28 Z

I have a client whose workflow heavily relies on the use of autotext. They currently use Word 2003 which shows a preview of the autotext as they type. I am migrating their macros to Word 2007/20010 VSTO but am unable to provide them with the same autotext functionality in the newer versions of Word.
I am aware that autotext is supported in 2007/2010 versions of Word as building blocks and autocomplete is activated by pressing the F3 key. However it is not possible for them to remember all their abbreviations for thier many autotext entries and they rely on the preview of the autotext as they type.

How can I replicate Word 2003 autotext functionality in Word 2007/2010 and enable autocomplete of autotext with autopreview?

Where can I find the Formula Bar ObjectModel and related formula bar functions in VSTO?

Wed, 25 Nov 2009 06:54:48 Z

Hi everyone,

Where can I find the Formula Bar ObjectModel and related formula bar functions in VSTO? I have tried to searched this for about 3 days, can any one help?

HOW TO GET HIGHLIGHTED TEXT ON THE ACTIVE DOCUMENT

Wed, 25 Nov 2009 08:02:31 Z

I'm trying to get the text i highlight on the active word document into a variable in c#. I'm wondering how to work it out because, people talk about range and stuff like that, HELP ME

User-defined function (UDF) using multi-threading and Asynchoronous socket?

Wed, 25 Nov 2009 08:13:34 Z

Could someone answer me about User-defined function (UDF) using multi-threaded mode and asynchronous socket:

Can Excel allow formulas using many UDFs to update data in Cells simultaneously?

Namely, UDFs use background threads and/or asynchronous socket to retrieve data from a server.
Accordingly, if 2 cells contain 2 UDFs to get data from server(s), whether they must wait for each other to finish or independent retrieving data.

As far as I know, Excel will lock all other cells before the current cell complete getting data! This makes the formula references to be in order and the calculation stable.

I have a dialog box, it will add some UDF formula into cells. These UDFs take time to wait server to answer then fill returned values (of course, plus formulas) in cells, but I want to work in other cells without waiting.

Does it exist a possible solution to overcome the delay of GUI interaction and UDF formulas?

So far, I have not tested the solution of UDFs using background thread and socket in asynchronous mode.

Please share your experience about this.

Sincerely yours

Peter Kieu

Unsinatlling the previous version of addin

Wed, 25 Nov 2009 04:01:56 Z

I have made a VSTO word addin in VS2007 and made an insatllable for it.It deploys successfully the first time on any other machine .
If later I try to install a modified version of the same addin ,it says that the -
"The customization cannot be installed because another version is currently installed and cannot be upgraded from this location. To install this version of the customization, first use Add or Remove Programs to uninstall this program:"
So i go and remove it from "Add/remove program" and then insatll my modified addin.
I want my code or by config setting to check everytime before installing a new version of the addin to check that if previous version is existing remove it and then insatll the new version.So basically I need to do away with the manual activity of removing previous vesrion of addin.
Is it posssible ,if yes let me know how.

Thanks
Anand

How can I customize the built-in TaskPane in Word using VSTO?

Wed, 25 Nov 2009 06:32:09 Z

Hi guys,

I need your help.

I have a document which is already protected by protection functionality in Word. When I open the doc and try to edit the area which I don't have the right to edit, a taskpane appeared in the right of the document. There are two buttons in the taskpane: "Find Next Region I Can Edit" & "Show All Regions I Can Edit".

I really don't to see this happen. It's quite annoying. Is there anyone can tell me how can I customize the behavior of the built-in taskpane in Word using VSTO 2005? How can I get the designated TaskPane Object using VSTO like "Restrict Formatting and Editting Taskpane"?

Thanks！

Best Regards,
Kevin

Unable to get collection of hyperlink in excel using Microsoft.office.interop.excel

Wed, 25 Nov 2009 10:58:19 Z

Hi:

I'm trying to get all the hyperlinks in a column. I know there is one way by iterating through whole excel row by row. As I don't know size of excel, so don't want to go for.
Another way is to get all the hyperlinks in a column ( as i knows that it will come only in one column.). I'm able to get the hyperlink in a column.
Now my job is to put in DB, by inserting the hyperlinks with other data in a column. But here a little twist. I'm unable to convert the hyperlink object to either a string object or a an object. If I'm try to do same, I gets an error.
Could any one tell me how to get a collection of hyperlinks, in an excel column, in a collection.

Dharamvir

Infopath Textbox_changed Event not fired

Wed, 25 Nov 2009 11:46:14 Z

Hi
I have a native infopath form with code behind. I publish the form as content type to a sharepoint forms library. Once the form is filled, the filled form is saved in the same forms library using data connections.When the user is filling out the form from the template, the event is fired. For example:

public

void txtPMEmail_Changed(object sender, XmlEventArgs e){Section3Instructions();}

But if I open the saved form from the forms library and make some changes in the text box, the txtPMEmail_Changed event is not fired.

Thanks in advance
Jas

VSTO compilation from command line without using MSBuild

Wed, 25 Nov 2009 11:25:56 Z

Is there any command or set of commands that I can use from the command line to build an Office 2007 Addin written in C#? I am using VS2008 SP1 Professional edition.

Using the CSC command line, I am able to generate the dll.

However, I also require the "VSTO" and "MANIFEST" files to be generated. Is there any option that I can provide to CSC or any other command line (except MSBuild) that I can use?

SharePoint deployment of VSTO Document Level Customization - doesn't get installed

Wed, 18 Nov 2009 06:54:26 Z

Hi,

I have developed a very simple document level word template using VSTO v3. I followed the steps for provided in the deployment article.

When I upload the 'Document Template' to SharePoint library, the customization didn't show up and there is no error to figure out why it is not loading. However, when I run the template from Shared location, the customization installs correctly. I am not sure if I miss something silly on SharePoint side.

Steps I followed:

1. Created a document template from VSTO v3 and added a ribbon control and a button to the ribbon.
2. Then in the publish tab of the solution, provided the 'Shared folder' location in both 'Publishing Folder Location' & 'Installation Folder URL'.
3. Published the solution to the shared location
4. Uploaded the 'Document Template' to SharePoint library
5. Added both 'SharePoint library' & 'Shared folder' location to Trusted Locations in Word

After completing all these steps, when I open the template from SharePoint library, the customization doesn't get installed.

Any help would be much appreciated.

Mohan

How can I set Outlook tasks to read-only programmatically?

Tue, 24 Nov 2009 10:09:45 Z

Hi,

Does anyone know if its possible to set Outlook task to read-only programmatically?
Thanks in advance!

Regards, matixsc

How to make a VSTO add-in impliment the IRDTServer interface

Wed, 25 Nov 2009 10:01:15 Z

Hi,

How does one use a VSTO add-in class to implement an RdtServer. I'd like a get a handle to the application object of my ThisAddin class and use it to call the WorksheetFunction.RTD method in Excel 2007. I have tried

Public partial class ThisAddin : IRtdServer

but none of the interface events fire when they should. An option is to implement a shared add-in using IDTExtensibility2 interface and I use the OnConnection method to access the Application object. But I have to create a shim for isolation and so on. The class signature would be

public class MyRtd : IDTExtensibility2, IRtdServer

How do I do the same with a VSTO add-in? Is it possible? All implementations of RTDServers i've seen online use the shared add-in/IDTExtensibility2 method. Any help would be appreciated.

What a brilliant forum!

Gikx

How can replace the blank folder icon with user-defined one?

Tue, 24 Nov 2009 07:37:03 Z

I am working on add-in project to OL 2007, which is a VB project. We create a new page on appointment form, but we can not find the entry to replace the ICon on the toolbar, by default a blank folder icon is used. Is possible to replace the default icon on?

Thanks

VSTO startup slowly "generatePublisherEvidence" does not work

Wed, 25 Nov 2009 07:47:03 Z

Hi,

I create an addin for microsoft project 2003 and 2007 with vsto 2005se and vsto3.0. There're 3 projects in the solution. Project 2003 addin, project 2007 addin and a common project. Project 2003 addin and 2007 addin share the same forms, logics which are in the common project. Project 2003 addin references vsto2005se while 2007 references vsto3.

For the 2003 addin,
To speed up the start up of the plugin. I change the the app.config
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<runtime>
<generatePublisherEvidence enabled="false"/>
</runtime>
</configuration>

But when I use network profiling tool to monitor the network connections. The addin still try to access crl.microsoft.com. If I disable the "Check for Publisher's certificate revocation" in internet options. the addin does not access crl.microsoft.com any more.

Why the generatePublisherEvidence does not work?

Following is the files contained in the addin.
PPM_MSP_Plugin2003.dll.manifest
PPM_MSP_Plugin2003.dll
PPM_MSP_Plugin2003.dll.config
PPM_MSP_Plugin2003_SetSecurity.dll
PPM_MSP_Plugin_Common.dll
log4net.dll

"PPM_MSP_Plugin2003.dll.manifest" is the deployment file of the addin. "PPM_MSP_Plugin2003.dll" is the addin. "PPM_MSP_Plugin2003.dll.config" contains the generatePublisherEvidence parameter. "PPM_MSP_Plugin_Common.dll" contains the forms, logics of the addin.

Am I do anything wrong?.

Thanks.

How to deselect mail item from ActiveExplorer().Selection

Mon, 23 Nov 2009 20:35:35 Z

Hello,

I'm using

//Get current selected items.

Outlook.ApplicationClass app = new Outlook.ApplicationClass();
Outlook.Selection sel = app.ActiveExplorer().Selection;

to get the selected mailitems and
use a foreach loop to write the mails to a directory.

when the copying is finished i want to remove the copied item from the selection.

How can i do that?

Thanks,

Hans

Adding a new Window to outlook using Outlook Addin in Visual Studio 2008

Tue, 24 Nov 2009 06:41:45 Z

Hi,

I am trying to customise my outlook to display an extra window/column.We have common windows, like List of folders on the left, Inbox in the right. My requirement is to add another window/column after the inbox, in the right side so that when i open outlook it will display 3 columns.

I tried adding a FormRegion , but that is getting displayed only when the readingpane is opened.I also tried using windows forms, but it opens as a new window.I want the window inside outlook itself.

Any help is appreciated.

Finding mage.exe on a client machine

Thu, 19 Nov 2009 21:29:47 Z

Hi All,

I recently sought advice on dealing with an identity error when re installing a VSTO addin on a client machine (see http://social.msdn.microsoft.com/Forums/en-US/vsto/thread/d7d57446-f0b2-4b9e-96b8-966218306ddd)

I was offered the following suggestions.

1. Open command prompt by inputting cmd in Run from Start menu.
2. Switch to the path which mage.exe is in. In my side, the path is C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin. Input "cd C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin".
3. Now input Mage.exe -cc . It will appears a notice: Application cache cleared.

My problem is that my client claims that the sub directory C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin does not exist on his computer. Does this subdirectory exist only on the developer PC? If so, how can the appkication cache be cleared on my client's PC?

Best regards,
Bernie

How to load the GAL into dropDown in Ribbon???

Tue, 24 Nov 2009 05:05:03 Z

I have created a dropDown in ribbon of outlook, now I need load the name of employees from Global Address List into it.
I use the method as follow, but it works very very very solw, somebody help me?   Thanks!

private void myRibbon_Load(object sender, RibbonUIEventArgs e)
        {
            Outlook.Application objOutlook = new Outlook.Application();
            Outlook.NameSpace objNS = objOutlook.GetNamespace("MAPI");
            Outlook.AddressList objAddressList = objNS.GetGlobalAddressList();

            for (int i = 1; i < objAddressList.AddressEntries.Count - 1; i++)
            {
                Outlook.AddressEntry addrEntry = objAddressList.AddressEntries[i];

                RibbonDropDownItem ResponsibleGAL = new RibbonDropDownItem();
                ResponsibleGAL.Label = addrEntry.Name.ToString();
                dropDown1.Items.Add(ResponsibleGAL);
            }

Print Outlook attachment from add-in code

Mon, 23 Nov 2009 15:20:12 Z

Hi all,

I am developing an Outlook add-in and want to add a feature that prints out attachments of e-mail messages.
Exactly as Outlooks does when you go to the File menu, Print... and check the "Print attached files. Attachments will print to the default printer only" checkbox.

Does anyone has a code sample about how to achieve that, after I have the EmailItem object selected?

Many thanks!
Mauricio.-

Multiple BCC using Interop.Outlook

Mon, 23 Nov 2009 15:03:54 Z

Hi,

I need to add some recipients to a Mail Object in the BCC space.

I use Recipients.Add syntax (but the addresses are added to To space).

If I use oMsg.Bcc syntax the ";" character is not inserted (??)

Do you have any idea about the problem ?

Microsoft.Office.Interop.Outlook.Application oApp = new Microsoft.Office.Interop.Outlook.Application();
Microsoft.Office.Interop.Outlook.MailItem oMsg = (Microsoft.Office.Interop.Outlook.MailItem)oApp.CreateItem(Microsoft.Office.Interop.Outlook.OlItemType.olMailItem);

foreach (ListViewItem _lvi in lvwPeople.Items)
{
if (_lvi.SubItems[20].Text.Trim() != string.Empty)
   {
      //oMsg.Bcc += _lvi.SubItems[20].Text.Trim() + ";";;

       oMsg.Recipients.Add(_lvi.SubItems[20].Text.Trim());
   }
}

                oMsg.Display(false);

                oMsg = null;
                oApp = null;

How to use Outlook Mailfolder as a DataSource to GridView control

Fri, 20 Nov 2009 18:52:39 Z

Using Outlook Interop, can I directly bind a gridview control to display my messages (for example I'd like to display my Inbox messages for a certain date. Sample code show below.

If so, I'm looking for how to select a message and open outlook to display or edit the message.

Here is some sample code, perhaps someone can help me fill in the blanks...

Dim

oApp As Outlook.Application = New Outlook.Application()

Dim oNS As Outlook.NameSpace = oApp.GetNamespace("Mapi")

Dim oInbox As Outlook.MAPIFolder = oNS.GetDefaultFolder(Outlook.OlDefaultFolders.olFolderInbox)

Dim selecteddate As String

selecteddate = Format(

Me.SelectedDate.Value, "yyyy-MM-dd")

oInboxItems = oInboxItems.Restrict(

"[ReceivedTime] >= '" & selecteddate & "''")

Me.dgvInbox.DataSource = ?????

Me.dgvInbox.DataMember = ?????

Manually I've been able to populate a datatable by enumerating each mail item and bind to it but looking for a more direct approach.

Is there an Outlook Control?

dynamically adding checkboxes to a RibbonGroupBox

Tue, 17 Nov 2009 08:56:13 Z

Hello,

i'm having problems using a RibbonControlGroup to which i want to add several checkboxes dynamically. The RibbonControlGroup is in a Grid in a RibbonGroup! I get the CheckBoxes to be added into the RibbonControlGroup by using some code like this:

RibbonCheckBox me_chkBox= new RibbonCheckBox();
RibbonCommand Command = new RibbonCommand();

me_chkBox.Name = "chkBox_" + myDokTyp;

Command.LabelTitle = myDokTyp;
me_chkBox.Command = Command;


this.me_controlGroup.Controls.Add(me_chkBox);

when i use this code my checkboxes are visible in the middle of the RibbonControlGroup one by one from left to right like this:

check1 check2 check3

if i use me_chkBox.VerticalAlignment = VerticalAlignment.Top; for each checkbox before adding it to the GroupBox the checkboxes aren't starting in the middle of the RibbonControlGroup , but from the Top (which is good) but as well they are ordered from left to right.

In fact i want them to be ordered from the top to the bottom on the left side of the RibbonControlGroup like this:

check1
check2
check3

What do i have to do to get the checkboxes to be ordered in the correct order? (from my point of view)
If there is a better way for getting controls dynamically added to a Grid inside a RibbonGroup pls let me know!!

I'm using:
Windows XP Professional
Microsoft Visual Studio 2008 Version 9.0.30729.1 SP
Microsoft .NET Framework Version 3.5 SP1
RibbonControlsLibrary 3.5.31016.1

I hope you understand my problem!

Can't pass parameters with a UDF

Tue, 24 Nov 2009 23:48:06 Z

Hello,

I have tried to make my own udf with the instructions from Eric Carter's post "Writing user defined functions for Excel in .NET" (http://blogs.msdn.com/eric_carter/archive/2004/12/01/writing-user-defined-functions-for-excel-in-net.aspx).

I get a strange problem, when I pass values there is no problem (=MultiplyNTimes(1;2;3) == 8 ) bu when I pass a refrence to another cell i get #value! ( =MultiplyNTimes(A1;2;3) ).

I'm using Excel 2007 and VS 2008.

Is there any one that has got this problem and what is the solution?

Thank you!

--Johan