We’re very obliged to David Peel for pointing out where we and ChatGPT had gone off the rails. Unfortunately, ChatGPT’s system can’t make a distinction between code for Excel, Word or PowerPoint – at least not for selecting a file.Īsking “Word VBA to choose document then open it”, “PowerPoint VBA to choose document then open it,” “Microsoft Office VBA to choose document then open it” and other variations all suggested the same incorrect code line. Ask “Write Word VBA macro to open a document” and it shows some code to do that … Write Word VBA to open a documentĪ basic starting point for any Office VBA is selecting a document then opening it. In ChatGPT itself there’s a “Copy Code” button at top-right of the black code box. That especially applies to Outlook VBA which can seem like an impenetrable mystery to novices.Īll the code made by ChatGPT is at the bottom of this article as text you can copy to use yourself. While it might need some enhancement, ChatGPT gives you a starting point and shows you the methods and properties to explore. We’re obliged to the Office Watch readers who shared their Office VBA expertise with us to improve and fix the original article. The VBA code was NOT always correct with one notable error (see below). Here’s some examples, we tried for Word, Excel, PowerPoint and Outlook.
Naturally, we wondered how it would cope with making some Microsoft Office VBA. Ask a question like “How to replace text in a string” and ChatGPT can make sample code in the language you choose. One geeky use is to produce simple chunks of computer code. People have used it to write whole paragraphs and even poetry! To find out more or signup to ChatGPT, go to Here’s some VBA made by ChatGPT for Word, Excel, PowerPoint and Outlook and some of it’s mistakes.ĬhatGPT is a trial site which take a simple request and returns some text. ChatGPT can be used to learn the basics of Microsoft Office VBA coding with examples made to order.
0 kommentar(er)
