Can i add an "add article" option to MS Word menu ?

[dimsis]

Is it possible to add a menu option to MS Winword 2002, via programming (vba, or visual basic) like the "Save as HTML" in the File menu, that connects to an internet database (SQL Server 2000) and inserts the working document into the db?
If something like this can be implemented, then we can give the option to our clients to continue writing their documents in ms word, and update their site with a simple "save article" option.
To do something like this i think we need:
- code (exe file /setup?) to automatically add the option to the menu
- VBA code that connects to a remote SQL Server database and inserts the word document as a database record (with some extra data for example a category id, or title which can be the first line of the word document or it's filename etc...)

Any suggestions how to do it?
Thanx in advance.

 

[simeybt]

I would say this could most certainly be done. the only thing i would be uncertain about is if you could store a word *.doc on the SQL server. Somebody else might shed light on this. But you can certainly customise Word to add a new option on the menu bar, you could also add a new button on to the toolbars that could also do this. This could all be performed using VBA(including the connecting to the database and uploading the file.)

Hope this Helps

 

[dimsis]

I don't even need to upload the word doc,
i've already manage to connect to a local SQL Server database through Word VBA and query one table and populate it's value into a combobox.
Now i only have to insert the Word document into the database as a record...
(i tried to connect to a remote database and it did'nt work, anyone has a tip on this?)