Save Document Information to SQL Server

[JPS]

We have an online document management system which allows our users to view
the documents via a web interface.

Currently our users use the web functionality to upload the documents but
this proves to be a time consuming task as the drives are internal only.

What we want to do is be able to create functionality in Word which is like
"Save to Doc Manager"

On click of this we want to the users to enter the Contract Id in a textbox
and the macro to be able to Save the file to a pre determined location and a
write an entry into the SQL Server Database i.e. Insert into Document
(ContractId, Filename) Values(40004, 'mycontractdoc.doc')

Is this possible and would be very greatfull for some sample code even if it
an outline.

thanks

 

[Cindy M.]

Hi Jps,

Which version of Word is involved?

We have an online document management system which allows our users to view
the documents via a web interface.

Currently our users use the web functionality to upload the documents but
this proves to be a time consuming task as the drives are internal only.

What we want to do is be able to create functionality in Word which is like
"Save to Doc Manager"

On click of this we want to the users to enter the Contract Id in a textbox
and the macro to be able to Save the file to a pre determined location and a
write an entry into the SQL Server Database i.e. Insert into Document
(ContractId, Filename) Values(40004, 'mycontractdoc.doc')

Is this possible and would be very greatfull for some sample code even if it
an outline.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail