AI systems have got a lot better at making and fixing Microsoft Office VBA code. We compare Copilot and ChatGPT to see which is best choice for coping with the complexities of Office VBA. Early in 2024 we tried asking ChatGPT for Office VBA code in some simple examples, the results weren’t great. A lot […]
Here’s how to easily install VBA code or macro in Microsoft Office. Adding some code you’ve seen on a web site or been given is simple once you know the little tricks. Often people are given some Office VBA code to use with Word, Excel, PowerPoint or Outlook but without instructions for how to install […]
VBA code or Macros can be copied between Microsoft Word documents and templates quite easily if you know where to look. We’ve seen people laboriously copying code between VBA editor windows, not realising there’s an easier way. It’s not entirely necessary but usually the two macro-enabled documents/templates are opened first. Open Macro Organizer Go to View […]
Until late 2022 an annoying omission from Excel and VBA was a simple way to combine or merge arrays into a single array. Here’s how to do it with VBA for older Excel releases. Excel 365 for Windows and Mac now have HStack() and VStack() which will combine dynamic arrays or ranges. The VBA method […]
The April 2020 security fixes for Microsoft Office come with a warning that some VBA code will stop working. There are workarounds to let some references through. The KB4557055 security fix blocks VBA references that link to Internet or intranet sources or have been downloaded from the Internet. That will effect some Office/VBA code which […]