Wrox Programmer Forums
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old November 18th, 2011, 06:26 PM
Friend of Wrox
Join Date: Jun 2003
Posts: 836
Thanks: 0
Thanked 0 Times in 0 Posts
Default Source Code Management


I've been away from p2p for many years, but thought of this community first now that I'm looking at a new kind of programming.

I'd like to start prototyping some Excel-based applications, but I can't stand that my source code is only stored inside my spreadsheet binary. I'd much prefer to maintain my code in a separate text file that I can easily version-manage in a source control repository. This will allow me to create feature branches, run diffs with other developers/versions, etc.

Is this even possible? I've searched around the web and haven't found a way.
Take care,

Old November 22nd, 2011, 05:07 AM
Friend of Wrox
Join Date: Sep 2005
Posts: 812
Thanks: 1
Thanked 53 Times in 49 Posts

You can export the Userforms, ClassModules and Modules as separate files and maintain that in any SourceControl tool (SVN etc)

But managing that by Importing to Excel is a tough job

This is one advantage of using VSTO Addin etc

C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Code to save html page source code? Jaymond Flurrie Access VBA 2 July 2nd, 2019 06:04 PM
Have you source code in c# ? surendra01 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 3 May 2nd, 2009 08:46 AM
Additional Code for the Management Folder. mcarol44 BOOK: ASP.NET 2.0 Instant Results ISBN: 978-0-471-74951-6 1 October 15th, 2007 12:40 PM
source code redeye2 Pro VB.NET 2002/2003 0 October 26th, 2004 09:39 AM
Source code bcshen All Other Wrox Books 1 April 19th, 2004 11:43 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.