Subversion and VBA

[da...@ubs.com]

We are moving to use Subversion and one area we'd like to be able to use
it is in controlling the VBA within Excel.  We could just submit the
whole spreadsheet, but it would be useful to be able to use Subversion
at the VBA level.  Are there any addins that enable this usage?

Regards,

David Jessop

This communication is issued by UBS AG or an affiliate ("UBS") to
institutional investors only. It is for informational purposes and is
not guaranteed as to accuracy, nor is it a complete statement of the
financial products or markets referred to. Opinions expressed are
subject to change without notice and may differ or be contrary to the
opinions or recommendations expressed by other business areas or
groups of UBS as a result of using different assumptions and criteria.
UBS may maintain long or short positions in the financial instruments
referred to and may transact in them as principal or agent. Unless
stated specifically otherwise, this is not a recommendation, offer or
solicitation to buy or sell and any prices or quotations contained
herein are indicative only. UBS may provide investment banking and
other services to, and/or its officers/employees may serve as
directors of, the companies referred to in this material. To the
extent permitted by law, UBS does not accept any liability arising
from the use of this communication. Additional information or UBS
Investment Research is available upon request.

Copyright 2006 UBS.  All rights reserved.  Intended for recipient only
and not for further distribution without the consent of UBS.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

Re: Subversion and VBA

[Andy Levy <an...@gmail.com>]

On 11/11/06, Andy Levy <an...@gmail.com> wrote:
> On 11/10/06, david.jessop@ubs.com <da...@ubs.com> wrote:
> > We are moving to use Subversion and one area we'd like to be able to use
> > it is in controlling the VBA within Excel.  We could just submit the
> > whole spreadsheet, but it would be useful to be able to use Subversion
> > at the VBA level.  Are there any addins that enable this usage?
>
> PushOK has a COM object you can install and use from any COM-aware
> environment (including VBA - however, I thought in either Office 2k3
> or Office 2K, they switched from VBA to a more WSH-like VBScript
> environment?). I tried it myself last winter but wasn't able to work
> out how to properly use it. I also can't speak to whether it's keeping
> pace with the official Subversion releases.

Sorry, forgot to include the URL. http://www.pushok.com/soft_svncom.php

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org

Re: Subversion and VBA

[Andy Levy <an...@gmail.com>]

On 11/10/06, david.jessop@ubs.com <da...@ubs.com> wrote:
> We are moving to use Subversion and one area we'd like to be able to use
> it is in controlling the VBA within Excel.  We could just submit the
> whole spreadsheet, but it would be useful to be able to use Subversion
> at the VBA level.  Are there any addins that enable this usage?

PushOK has a COM object you can install and use from any COM-aware
environment (including VBA - however, I thought in either Office 2k3
or Office 2K, they switched from VBA to a more WSH-like VBScript
environment?). I tried it myself last winter but wasn't able to work
out how to properly use it. I also can't speak to whether it's keeping
pace with the official Subversion releases.

I have a couple WSH scripts I use with my repository at work, and I
just use the shell objects provided by the WSH environment itself to
call the svn command-line client, then parse the output. The
Subversion tools were designed to generate output that's easily parsed
by both people and machines.

I wonder if it might be possible also to write code that interacts
with the DLLs from TortoiseSVN.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org