How to put SharePoint propertys inside a word or Excel document

[Robertohh]

I need to put the versión number of the SharePoint site document library as
well as the last modified date and the state of approval.
How can I do it inside a Word or Excel document.?

[Ganesh]

Hi Robertohh,

You may try writing VBA to retrieve version number, last modified date and
any other information using Lists.asmx web service from SharePoint and write
them using the same VBA to write into the Word or Excel document.

Here is some of the links that may be useful

http://msdn.microsoft.com/en-us/library/aa159897(office.11).aspx
http://the-simple-programmer.blogspot.com/2010/03/set-sharepoint-meta-data-from-vba-using.html
http://www.keyongtech.com/2007600-using-sharepoint-2007-web-service
http://www.sharepointdev.net/sharepoint--development-programming/listsasmx--getversioncollection--how-to-get-absolute-urls-of-older-versions-of-a-document-in-do-65868.shtml

Ganesh

[Robertohh]

The first link is more for access, I try the first line of code in Excel VBA
and do not work. And continue reading is for lists, not for the specific
document recently opened.

In the second link, you have to know the document name and the versión
number, and is exactly the data I need.

In the third there are no examples

In the forth I don't know how to access web services from word or excel VBA,
and the exemples are for vb.Net

The only think I really want to do is put the
SharePoint versión number, inside the document, the
number that I can see before I click the document
link and open it.

I prefer a solution without code because i have to put it in all the
documents of the library and then I have to sign every document so the macros
can open, and what will happen when the sign expires? but if there are no
other way then is ok.

I try to use in word insert-field-RevNum but it inserts 2 and the document
version is 0.1
when I choose LastSavedTime it makes minutes different date and I can not
use as a versión because it is different in some minutes from the one in
SharePoint.

by the way I'm using WSS 3.0 and Office 2003

Thanks
Help Please.

[Robertohh]

The only think I really want to do, is put the

SharePoint versión number, inside the document

[Veynom]

Hi Robert,

http://recyclableelectrons.blogspot.com/2009/06/how-to-include-sharepoint-document.html

5 minutes of work only.
Cheers,
--