Category: Talk about Excel VBA
1. Python in Excel Overview Yesterday (2023-08-22), Python in Excel was announced at Microsoft Tech Community. In the meantime, we have been using a separate library to link Excel and Python, but finally we provide linkage in a basic environment without the need for separate installation. Announcing Python in Excel: Combining the power of Python and...
Microsoft 365 Copilot was announced last Friday (2023-03-17). By integrating ChatGPT into Microsoft 365, it seems that it can significantly improve user productivity. I've been watching ChatGPT since the end of last year. ChatGPT is spreading faster than any software or service ever introduced to the world. ChatGPT 3.5...
VBE (VB Editor), an editor that codes Excel VBA, does not have a function to set dark mode among the provided functions. The following screen was mentioned in Excel VBA Lecture (5): Excel File Extension, VBE, Font Setting #2.7.4._VBE_Screen_Composition. As you can see in the image above, the VBE default screen is displayed in black text on a white background....
I have a new news related to VBA, so I write a brief article. From 2022-07-27, the execution of VBA macro files received from the Internet will be blocked. This is a security measure to prevent someone with malicious intent from distributing malicious code using macros. Only MS 365 Office apps running on Windows. Runs on Mac OS or installs...