Microsoft Office has just rolled out a fresh new look, with its suite of apps receiving a long-awaited facelift. As of yesterday, the familiar icons for Word, Excel, PowerPoint, Outlook, and more have been refreshed, giving the productivity tools a modern, streamlined design.
Continue reading
Working with large Excel files can be a challenge. As spreadsheets grow in size and complexity, they often slow down drastically, taking longer to load, calculate, or respond. Fortunately, there are several practical strategies you can implement to optimize performance and improve the user experience.
Continue reading
Did you see the new heading banner that appears when you go and access the (Microsoft) Access (Database) forum on Microsoft Answers?
We are excited to announce that soon, the Microsoft 365 and Office forum will be available exclusively Microsoft Q&A. This change will help us provide a more streamlined and efficient experience for all your questions and discussions.
Starting July 16, you will no longer be able to create new questions here in the Microsoft Support Community. However, you can continue to participate in ongoing discussions and create new questions on Microsoft Q&A. Thank you for your understanding and cooperation.
In recent years, the hype surrounding AI has permeated every aspect of our lives, including software development. While initially skeptical due to ethical concerns and copyright issues, curiosity led to exploring AI’s potential in code generation. After months of testing, using multiple programming languages (PHP, VBA, HTML, JavaScript), it’s clear that AI has both strengths and weaknesses in this domain.
Continue reading
Every once in a while I am provided data from client in Excel and want to use that information in SQL (SSMS, MySQL, …) to build some WHERE clause in a query. So I go back and forth, copy/paste, over and over. It’s tedious and time consuming!
There has to be a better approach.
Now, if you’re running Excel 365 then there’s a new function you can actually employ TextJoin(), but I’m not going to be discussing that here.
I wanted, needed, a universal solution for when on-site at clients, some of whom are running Excel 2003.
Yes, you read that right.
I recently started experiencing a new problem with Microsoft Excel where it won’t close when I click on the application’s close button, but only if I opened it through Windows Explorer.
This is something I’ve been wanting to do for quite a while, that is, to create a page dedicated to working with Dates and Times.
I was doing a little more advanced Date/Time VBA programming and decided that now was as good a time as ever to start creating such a page. So here it is.
This article will evolve with time, so come back from time to time.
After my recent post and video regarding Office 2024’s release:
I’ve seen a few questions on my YouTube channel and in various forums where people are trying to understand the difference between Microsoft 365 (also referred to as MS 365 or MS365) and this latest release of Office 2024.
As such, I thought this an important subject to cover.
Did you know, Office 2024 launched yesterday!
That’s right, if you want a perpetual license (1 time purchase rather than the MS365 Subscription model) of the latest and greatest version of Office then 2024 is now on the market.
Here’s Microsoft’s official announcement:
A bit of a weird one today.
I was in need to deleting some data in various columns within an Excel Workbook and instead of undertaking this task manually, I decided a little VBA function would do the trick and be much faster than I ever could be manually.
So basically, I wanted to randomly delete value from within a single column, or possibly randomly delete rows of data within a series of columns. For my needs, I came up with the following procedure:
