SubWCRev COM-object does not work in Excel - but in Word

Hi!!

I'm experimenting with the COM-object for reading version data in
Office application. Tried the following short VBA example that I found
to work in MS Word but not in MS Excel where I get error 424: Object
required when I try to use the GetWCInfo method.

But why can't I get COM to work in Excel??

The SubWCRevCOM.exe file is listed and selected under Tools ->
References
as LibSubWCRev.

The code:

Public Sub ReadMAIN()
    Dim oSvn As SubWCRev.Object
    'Set oSvn = CreateObject
    Set oSvn = CreateObject("SubWCRev.Object")
    oSvn.GetWCInfo ActiveDocument.FullName, 1, 1
    Debug.Print "Revision: " & oSvn.Revision
End Sub

Regards,
Tomas Sandkvist
Sweden

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe_at_tortoisesvn.tigris.org
For additional commands, e-mail: users-help_at_tortoisesvn.tigris.org
Received on 2008-06-24 13:41:12 CEST