[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

AW: AW: AW: SubWCRev program no more supporting VBA in V1.9x ?

From: Matthias Schäfer <Matthias.Schaefer_at_kopfweb.de>
Date: Tue, 30 May 2017 11:32:01 +0000

Dear Mr. Kueng,

after some researches i can definitely say, that the method .GetWCInfo (Svn.GetWCInfo ActiveWorkbook.FullName, 1, 1) is causing the error and only in conjunction with the VBA-Sub Private Sub Workbook_WindowActivate(ByVal Wn As Window) and only in the new version.

The reason could be: while activating the template in excel this error occurs, because there is not an information from the excel file, which has no file location until it is saved.
(But remembering its working with version 1.7X). The method should have an exit, if there is no info. How is it possible to get an result from the method?
I tried MsgBox, Variable and Debug.Print. Nothing is working.

He is the shortest possible sub I made for testing:

· The rrror occurs only in the new version

o On “Error GoTo” is not Working in this case

o “If oSvn.IsSvnItem = True Then Else” etc. is not working

The documentation says:
“Naturally you must call this before you can access the information using the remaining methods.”

So is this method really necessary? I made some tests without this method, I think it´s working without it?!
If you want to test, please try this in Excel (Word same problems, but not examined in closer detail):

Private Sub Workbook_WindowActivate(ByVal Wn As Window)
On Error GoTo Err

Dim oSvn As Object
Set oSvn = CreateObject("SubWCRev.object.1")
oSvn.GetWCInfo ActiveWorkbook.FullName, 1, 1

If oSvn.IsSvnItem = True Then
    MsgBox (oSvn.Revision)
    MsgBox ("Kein Svn")
End If

Set oSvn = Nothing
End Sub

Mit freundlichen Grüßen / Best regards

Matthias Schäfer

KOPF GmbH / Kapbachstr. 6 / 76829 Landau / Germany
Tel.: +49 6341 91767-33 / Fax : +49 6341 91767-50
Email: Matthias.Schaefer_at_kopfweb.de<mailto:Matthias.Schaefer_at_kopfweb.de>

Geschäftsführer: Oliver Kopf - HRB Landau Nr. 3090 - Amtsgericht Landau

Von: Stefan Küng [mailto:tortoisesvn_at_gmail.com]
Gesendet: Dienstag, 4. April 2017 20:38
An: Matthias Schäfer; users
Cc: Oliver Kopf; Bernd Jatz
Betreff: Re: AW: AW: SubWCRev program no more supporting VBA in V1.9x ?

On Tue, Apr 4, 2017 at 8:10 PM, Stefan Kueng <tortoisesvn_at_gmail.com<mailto:tortoisesvn_at_gmail.com>> wrote:

On 04.04.2017 12:03, Matthias Schäfer wrote:
Dear Mr. Kueng,

the bug is only for SVN upgraded version 1.9x!

the scenarios are:

Updated SVN 1.9x and SubWCRevCOM 1.7.11 = Working

SVN 1.7.11 and SubWCRevCOM 1.7.11 = Working

_SVN 1.9x and SubWCRevCOM 1.9x 0 Not Working_

So what can we do now? See facts below

- Documentation is gone since 1.9x for VBA.

Since we can't document every scripting language there is, there's no need for a specific VBA documentation - it's COM after all.
- Once SubWCRecCOM is opened in _updated_ package “1.9x” it is
growing bigger and bigger and “freezes”

- If SubWCRecCOM 1.9x is replaced with 1.7.11 it is working again!

- How can I check this error furher? (Tools, Dumps?)

What's the output of SubWCRev.exe for the path you use with SubWCRevCOM?
What's the output of 'svn.exe st -v path' for that path?

I've just created a word 2016 document and added a macro that uses SubWCRevCOM without any problems: I can read all properties with no issues.

  oo  // \\      "De Chelonian Mobile"
 (_,\/ \_/ \     TortoiseSVN
   \ \_/_\_/>    The coolest Interface to (Sub)Version Control
   /_/   \_\     http://tortoisesvn.net
To unsubscribe from this discussion, e-mail: [users-unsubscribe_at_tortoisesvn.tigris.org].

Received on 2017-05-30 13:32:12 CEST

This is an archived mail posted to the TortoiseSVN Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.