den2005

Hi,

Newbie using VSTO and developing office applications. The task is to import and export data from and to database, but user can select from a list columns what they want to add, there will be a dialog will appear and allow user to select data to be included in a word document, how can this be done I installed PIA, VSTO2005SE w/ runtime, MS Office 2003 Web Components and will use MS Office 2003 (ver 11.0.7969.0) with ASP.Net 2.0. I tried some links and cannot find Actions Pane Control. What Am I missing Can anyone point me to some sample codes or resources to do this

Thanks in advanced.

den2005



Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

Exactly what components should be working in which manner isn't clear from your description, but...

VSTO 2005 SE is specifically for creating application Add-ins. This means, the user starts the application (Word, for example) and works on documents. An Add-in provides general tools for this work.

VSTO 2005 SE does not provide a custom task pane for Office 2003, as custom task panes are only available in Office 2007. Nor does it provide an actions pane; actions panes are part of the full VSTO 2005 (without the SE). VSTO 2005 must be purchased as a separate application, unless you have the VS Team Suite.

So, you can't do what you describe with the tools you list in your message.






Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Hi Cindy,

    Thanks for the reply. You are saying there is no Action Pane Control in VSTO2005 SE and need full version of VSTO2005 and with Action Pane Control I could accomplished what I described. Right or need custom task pane to do this which is available with Office 2007 So, using Office 2007 I need VSTO2005 for Office 2007 too How about using xml to do this Loading data to xml and let word read the xml and display it. I found some links which is not clear how this can be done.

http://msdn2.microsoft.com/en-us/library/aa212883(office.11).aspx
http://msdn2.microsoft.com/en-us/library/aa223589(office.11).aspx
http://msdn2.microsoft.com/en-us/library/aa203674(office.11).aspx

Dennis

 

 





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

Hi Dennis

If the question is getting data into the document, then there are a number of possible approaches. You just can't use a "pane" in combination with a VSTO add-in. Here are some suggestions

1. You can create an Add-in and use a dialog box or commandbar as the user interface

2. You can create a Web interface, then feed the data into the document using XML (parsing the Word 2003 XML file), as you propose above, before the document is opened in Word. This would certainly be most efficient.

3. As (2), but you could use the full version of VSTO (which you currently don't have) with the ServerDocument functionality to put data in the data cache.

4. If you really want the UI in Word, in a pane, then you could create a SmartDocument solution. This is VSTO builds it actions pane on, taking a lot of the work off the developer's hands. The SmartDocument SDK starts here

http://msdn2.microsoft.com/en-us/library/aa295730(office.11).aspx






Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Thanks for info Cindy.

You mentioned I could use the xml approach, would I be able to fill dialog box or command bar to have drag down list of database columns and drop it to the word document. Is this possible or need VSTO to do that

Do I need VSTO when using SmartDocument SDK and how exactly I would use in this sdk to accomplish this task

Thanks.

Dennis





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Hi,

Do anyone knows a link where I could download an evaluation copy of Full VSTO 2005 My supervisor wants to evaluate this software if it is needed.

Thanks.





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

I'm afraid such a thing doesn't exist...




Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

VSTO is not required for any of the things you list above (although it could make them simpler to realize).




Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Thanks Cindy for info.

Another question, is there problem using vsto with ms office 2003 sp2 installed rather what document specified ms office 2003 sp1

 I think the bosses here might decide to purchase the full version of VSTO, but don't know why, is there volume licensing for this that say for 5 users that would be cheaper than (5 X US $ 799)

Dennis 





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

Hi Dennis

Office 2003 sp2 works, as well. But you have to be careful when updating it to install ALL the hotfixes. There were some problems with a couple of updates last spring that "broke" a few things in the automation interfaces. They've all been fixed, in the meantime, but you just want to be sure you install "everything" :-)

I have no information about licensing. I recommend you check with your local distributor about what's available along those lines.






Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Thanks Cindy..

Updates for both VSTO and Office or just for Office 2003. I need to clarify would I be able to create at all custom action panes using VSTO 2005 Full version with office 2003 or need VSTO 2005 for Office 2007 and Office 2007 The task I mentioned at start of this thread

 And do you know link or list of all updates need to install, I may be missed one of them.

 

Dennis





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

The updates that caused problems in the spring were all Office updates. Everything should be available from the Office updates site.

Full VSTO 2005 will let you create document-/template-level actions panes. These are an extension of the ISmartDocument interface; VSTO is taking something Office provides and making it much (much!) simpler to use. They should work in 2003 and 2007 (although I admit to personally having never tested taking a 2003 solution to 2007, yet).

VSTO 2005 SE will let you create application-level custom task panes for Office 2007, only. (Because earlier versions of Office don't have the concept of a custom task pane.)






Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

Thanks Cindy.

My co-wroker here is trying on a VBA approach to this same task, is it possible to do this in VBA, drag and down effect

Dennis





Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

Cindy Meister

Hi Dennis

I don't know what you mean by "drag and down effect". But all VBA-related questions you should address to the word.vba.general newsgroup, where you'll find a lot of people who specialize in the Word object model.






Re: Visual Studio Tools for Office using VSTO w/ ASP.Net 2.0

den2005

 

Drag and Drop effect, there is a dialog-like control floating when you open a word application inside this box are one of things are a list of database columns of a particular table, and when drag one of the item and drop the selected item inside the word, there is data will appear depends on certain filters. Preferably you can place this item anywhere in the word document.

Thanks for Cindy, having patience answering my questions.