Hacker News Reader

Can you even "review" changes to spreadsheet code? I know that Office apps have some support for change management, but is it even up to this task?

View on HN

There is actually pretty nice diff / compare two spreadsheets functionality inside of Excel.

Screenshot: https://support.content.office.net/en-us/media/9149c7e8-6f0c...

Seems to be dependent on what edition of Excel you have - I had a look for it and couldn't find it... (I'm using the up to date version from Office 365).

Open the Quick Access drop down menu and select More Commands.

In the Excel Options dialog box, select All Commands under Choose commands from.

In the list of commands, scroll down to Compare and Merge Workbooks, select it and click the Add button to move it to the right-hand section.

You need to use the Professional or ProPlus versions...or https://www.xltrail.com/

RubberduckVBA >> export all modules, classes, userforms >> send to git.

That was my release workflow. Worked for the +30k line application I built in VBA.

Reply on news.ycombinator.com