How do I automate document insertion into Sharepoint libraries ?

[foosy]

WSS provides an easy interface for uploading documents and creating a
library.
I am looking for a way to automate the insertion of word documents into
one such library.
How do I do this ?

A little more details follows...
The documents are created based on a template. Each new document is
saved (through a macro) with a name that is based on parameters found
in fields inside the document. All documents are saved in the same
folder on a server. This is also the server running WSS.

I would like that macro to also insert the document into a WSS library
and also fill some fields based on data in the document. How do I do
that ?

Thanks,
--Foosy