none
want to identify WPF object through Excel Macro RRS feed

  • Question

  • Would really appreciate if anyone can suggest a detail description how to identify WPF object through Excel VBA/Excel Macro. I got wpf in Excel reference but don't know how to use it in order to dentify WPF object.

    Thanks for your help in advance!

    Regards,

    Debprasad

    Wednesday, December 4, 2013 2:03 PM

Answers

  • Hi,

    Based on my understanding, you want use WPF feature control in excel, I suggest to use VSTO add-in. You can get start with :http://msdn.microsoft.com/en-us/office/hh133430.aspx

    Then you can use WPF control in action panel or task panel. Any UI element that can host Windows Forms controls in an Office solution can also host WPF controls.

    You can refer to the link below:

    #Using WPF Controls in Office Solutions

    http://msdn.microsoft.com/en-us/library/bb772076.aspx

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 6, 2013 7:45 AM

All replies

  • Hello Debprasad97,

    Could you please clarify your final goal? Why do you need to identify a WPF object from the VBA macro?

    Wednesday, December 4, 2013 2:24 PM
  • Actually, I wanted to perform some operations on WPF application using excel macro like selecting a Menu etc. I saw there was add-in for WPF in excel 2010 but how to use those, can u pls guide me.

    Thanks

    Thursday, December 5, 2013 5:09 AM
  • Can anyone pls help to resolve above problem.
    Friday, December 6, 2013 5:55 AM
  • Hi,

    Based on my understanding, you want use WPF feature control in excel, I suggest to use VSTO add-in. You can get start with :http://msdn.microsoft.com/en-us/office/hh133430.aspx

    Then you can use WPF control in action panel or task panel. Any UI element that can host Windows Forms controls in an Office solution can also host WPF controls.

    You can refer to the link below:

    #Using WPF Controls in Office Solutions

    http://msdn.microsoft.com/en-us/library/bb772076.aspx

    Regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Friday, December 6, 2013 7:45 AM