Excel and VBA- category -
-
Quicker access to Word and Excel "pinning files and folders"
If you have files that you open frequently, such as Excel, it is helpful to have them pinned. The quicker you can open them, the less stress you will experience. It's easy to do, so let's pin it. To pin a file, first open Excel. Select "File" in the upper left corner. Select the file you used... -
How to clear the history of recently used items in Word and Excel
Office is personalized and frequently shows a history of recently used items. This is fine for my own use, but if I happen to use it, or if I give my computer to someone else, I want to delete the history. The same is also true if you are handing over a company computer during a handover period. Now... -
Excel sheet display for simplicity.
When you give someone an EXCEL sheet, it is a good idea to keep the sheet simple. The less information you see, the simpler it will appear. At the very least, you want to keep it to one Excelno sheet. Also, if you want to go further, you can eliminate the sheet view... -
The importance of clarity to our future selves.
I had to fix some VBA programming that I wrote about 5 years ago to adapt it to the current form. The programming was the result of trying to make it somewhat easy to understand even back then. It was easy to maintain, but there were places where I felt there was one more step to be taken. That's how... -
How to convert from an image as text in an Excel data table
Excel has the ability not only to place images, but also to read text from those images and convert them into data. Although you should not infringe on intellectual property created by others, the method of converting text from images into text and tables is very useful in data processing. [Image data selection... -
How not to show Excel's "Recently Used Items" on a customer's computer.
Microsoft Office is mostly used by individuals. But if you share a computer or use someone else's secondhand computer, you may be interested in its history. To make it easier to search, the history is clearly visible in [Recently used items] and so on. The items that your boss used pa... -
In-house Client Motivation for Software Modification
Modifying software programs can be a painstaking task. Program-like tasks that can be done by the person in charge include the use of VBA and RPA. In this case, it is necessary to reassess the assumptions. What processes have been prepared, and what processes have been ... -
Let's get the new information of the Web site by Excel.
Excel allows you to retrieve information from the Web without using a browser. Although it is most often used for stock trading, Excel can also be used to retrieve information such as law amendments and notices. Let's try using the IRS page as an example.  ... -
6 ways to enter last year in Excel using only month and day input.
Accounting work in January will involve entering December dates. The problem with Excel input at the beginning of the year is that the year of the year is automatically entered when entering the month and date. For example, enter "12/28". After the actual input decision, this year (2020) is automatically added. The year cannot be fixed... -
Use in SFA TRANSPOSE and CONCATENATE functions to change column data to comma delimited
This section explains how to comma-separate data contained in multiple Excel cells for better data exporting and processing. Data management is becoming more and more accessible without programming, but a little ingenuity is still required for users...
12