none
VSTO: Best Click Once Strategie RRS feed

  • Question

  • Hello,

     

    This image shows what i want to do:

    Green: this is what i need:

    1) Some UserDefinedFunctions

    2) Some Document-Level-Projects

    3) Some Application-Level Projects

    Blue: DLL's i have to create / Code i have to write

    The questions are:

    1) are these Blue boxes ok like this? (And is this called a VSTO?)

    2) What do i need to add some UDF's? Can i put them into "shared DLL"? Or should i create a new one?

    3) Is using GAC the best way?

    Orange: How i want to deploy this solution

    The questions are:

    1) Is it possible this way? (installing a DLL to GAC via ClickOnce prerequisite)

     

    Every comment, feedback, help... is greatly appreciated!


    Sign by Danasoft - Get Your Sign

    Monday, November 21, 2011 2:11 PM

All replies

  • Hi theXploit,

     

    Thanks for posting in the MSDN Forum.

     

    <<are these Blue boxes ok like this? (And is this called a VSTO?)>>

    It’s based on my experience that Document-level project and Application level project is VSTO project. And the Connection assembly of SQL Server and the UDF are class library.

     

    <<What do I need to add some UDF’s? Can I put them into “shared DLL”? Or should I create a new one? >>

    It’s based on my experience that UDF will be a signal project. You need create a Class Library project to address it. It’s more like a shared DLL. It can be implemented everywhere on your local machine.

     

    <<Is using GAC (Global Assembly Cache) the best way? >>

    It’s hard to say whether this is the best way or not, it’s depended on your experience, the environment, your prerequisites of your project etc.

     

    <<Is it possible this way? (installing a DLL to GAC via ClickOnce prerequisite)>>

    Yes, you can do it. Please follow http://msdn.microsoft.com/en-US/library/ms165429(v=VS.100).aspx to create your Click prerequisite.

     

    I hope what I said can help you.

     

    Have a good day,

     

    Tom


    Tom Xu [MSFT]
    MSDN Community Support | Feedback to us
    Wednesday, November 23, 2011 5:58 AM
    Moderator
  • Thank you for your help Tom!

    My New Concept looks like this:

    The questions are:

    Application Level:
    ? Should I go for a VSTO or an XLL
    I read alot about this stuff but some of the points are not that simple. And i want to understand the full consequeces before i start coding...

      XLL Advantages:
       - higher performance
       - i can show some information to the functions/parameters
       - i dont need VBA wrapper for UDF's
       - Bad interaction with Excel-Object-Model -> What does that mean exactly? (What things i can't do? or i just need more code?)
       ? Is it possible to deploy it with ClickOnce? As prerequisit or as part of the VSTO?
       ? I read that with XLL you cannot use databinding for NamedRanges / ListObjects (Do i need this for what picture 2 (next post) shows?)
       ? What about the interaction between the XLL and my "shared DLL" which is located in the GAC (previous post)

    VSTO Advantages
       - Easy deployment with "Multi Solution Click Once"
       - Databinding for NamedRanges; ListObjects (picture 2 (next post))
       - Easy interaction with Excel-Object-Model -> What does that mean exactly?
       - Every Function need a VBA wrapper
       - Easy interaction with my "Shared DLL" which is located in the GAC (previous post)

     

    Document Level:
    ? If i use an XLL (so i dont need to use wrappers for UDF's) should i write the document specific UDF's also in the XLL? 

     

    To decide what yould be best for me:
    For me important is...
    - deployment, update (as few as possible work to update these components)
    - no dublicate code or as few as possible.. (thats why i set up a "shared DLL")
    - Things i want to with this tool!! -> next post

    I could not upload another image therefore please see also next entry...

    Any help, information or hint will be gratly appreciated!
    Cheers


     

    Sign by Danasoft - Get Your Sign

     


    • Edited by theXploit Monday, December 12, 2011 1:11 PM
    Monday, December 12, 2011 12:48 PM
  • ...sequel:

    What my programm should be able to do:

    1.) First of all i want to create some UDF's; Not only with skalar output (a single Value) also with
    The UDF gets some data from our DB to show it in Excel.

     

    2.) Second important feature i want to implement are some "Custom Task Panes"(appl. level) or "Action Pane"(doc. level) to be able to control some parameters...

     

    3.) The last important feature are some "Ribbon Customizations" to make some functions available drectly from the Excel ribbon.

    For your time!!!
    THANK YOU!


    Sign by Danasoft - Get Your Sign

    Monday, December 12, 2011 1:00 PM