{"id":3255,"date":"2013-04-29T09:14:21","date_gmt":"2013-04-29T09:14:21","guid":{"rendered":"http:\/\/www.microsofttraining.net\/b\/vbatraining\/?p=37"},"modified":"2023-12-31T00:16:50","modified_gmt":"2023-12-31T00:16:50","slug":"excel-vba-2013-track-changes-with-the-inquire-add-in","status":"publish","type":"post","link":"https:\/\/www.stl-training.co.uk\/b\/excel-vba-2013-track-changes-with-the-inquire-add-in\/","title":{"rendered":"Excel VBA 2013: Track Changes With the Inquire Add-In"},"content":{"rendered":"

\"new<\/a>Comparing and tracking changes in a spreadsheet is hard work. It’s utterly necessary but that doesn’t make it any easier. When you start adding in modifications to the VBA code underneath – which is not immediately obvious – there’s a mountain of things to screen. If a colleague has modified a module you’ll have to resort to third-party tools such as Visual Studio<\/a> to monitor for code changes. Arguably it’s a sledgehammer to crack a nut.<\/p>\n

We’ve previously talked about how the Inquire Add-In can help regulate your formulas and examine differences<\/a>. Inquire is not just limited to the cells. Inquire will also check for changes within the Visual Basic Editor.<\/p>\n

\"excel<\/a>Simply point it in the direction of your two files, ensure the Macros box is checked and let it do its magic. You’ll get a list of procedures that have changed along with the text output. It still doesn’t drill down to every specific character but in a complex project it will get you closer to what’s happened.<\/p>\n

How to: Enable the Add-in through File > Options > Add-Ins, from the Manage drop-down choose COM Add-Ins > Go. Tick Inquire and click OK.<\/strong><\/em><\/p>\n

To use it select the Inquire Tab in Ribbon > Compare Files. Browse to your files and click OK.<\/strong><\/em><\/p>\n

For training on Excel VBA 2013 and other versions, browse\u00a0Excel VBA training courses from Best STL<\/a>, available London and UK wide.<\/p>\n","protected":false},"excerpt":{"rendered":"

Comparing and tracking changes in a spreadsheet is hard work. It’s utterly necessary but that doesn’t make it any easier. When you start adding in modifications to the VBA code underneath – which is not immediately obvious – there’s a mountain of things to screen. If a colleague has modified a module you’ll have to […]<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[19],"tags":[571,574,582,611],"class_list":["post-3255","post","type-post","status-publish","format-standard","hentry","category-vba-training","tag-vba","tag-vba-training-london","tag-visual-basic","tag-working-with-files"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/3255","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/comments?post=3255"}],"version-history":[{"count":1,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/3255\/revisions"}],"predecessor-version":[{"id":6872,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/posts\/3255\/revisions\/6872"}],"wp:attachment":[{"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/media?parent=3255"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/categories?post=3255"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.stl-training.co.uk\/b\/wp-json\/wp\/v2\/tags?post=3255"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}