Meta Thinking, Meta Working
This article examines the differences in Excel file extensions, VBE (Visual Basic Editor), and recommended font settings. This is a continuation of the previous article. Excel VBA Lecture (4): Handling Excel Object Model 2.6. Excel file extension Excel versions prior to 2007 had only one extension, '.xls'. Since Excel 2007 '.xlsx', 'xlsm', 'xlsb'...
In this article, we will look at how to handle the Excel Object Model. 2.4. Understanding the Excel Object Model with Simple Code 2.4.1. Basic Object Access Let's look at the most basic code that accesses files, sheets, ranges, and cells. For reference, the global object Application can be omitted when accessing the object. 1 below...
2.3. Excel Object Model Excel VBA is a programming language that handles Excel. More precisely, it is a language that handles Excel's Object Model. You need to know how Excel is structured to be able to handle it well. If you understand just one picture below, the most important and frequently used in Excel Object Model...
2. Excel VBA Basics 2.1. Basic Environment Settings To use VBA-related functions, first set the Developer tab to be visible on the Excel ribbon menu. Depending on the Excel version, the displayed screen is slightly different, but the method is almost the same. Run Excel and proceed with the following steps to set it up. File > Options >...
This is the first article of the main part of the previous Excel VBA lecture preview. Welcome to the Excel VBA course. (Lecture notice, feat. Reason for recommending Excel VBA) 1. Excel VBA Overview A function written in VBA language similar to VB is called Macro. 1.1. VBA, Macro concept VBA (Visual Basic for Application) is a development language (and...
I am planning to organize the Excel VBA PPT materials that I presented to company employees a few years ago and post them on my blog. It may be a little difficult for those who have no coding experience in programming languages, but I will try to explain it as simply as possible. 😅 If you use Excel VBA well, your work productivity will increase and the quality of your output will increase....
The entire table of contents of the explanation about the work distribution optimization tool using the one-dimensional bin packing algorithm is separately organized. I put a link in the entire table of contents so that you can find the contents of this article as an index. 1. Overview of 1D Bin Packing Optimization Algorithm 1.1. Necessity of Bin Packing 1.2....
1. The description of the one-dimensional bin packing tool written on the summary of changes blog is based on 2017-11-19. Related article: Work distribution optimization using one-dimensional bin packing algorithm_1. Overview – Productivity Skill (prodskill.com) There are improvements while carrying out the K company project on 2021-03-21, so they are organized separately. Item Size from Integer (Long) to Real (Double)...
The source code of this article is based on the first version of the Bin Packing tool. Please refer to the latest version with improved functions. 1D Bin Packing Tool Recent Changes (as of 2021-03-21) 5. Attachment 5.1. Excel VBA-based tool source code Bin implemented with Excel VBA...
3.2. Using the Python Bin Packing Package 3.2.1. Introduction and Installation of Python Bin Packing Package The Bin Packing package that can be used in Python is provided at https://pypi.python.org/pypi/bin-packing-problem/1.0.0 on the Pypi (Python Package Index) web page. A brief description of the Bin Packing package and example source code can be found at this URL,...
English 
한국어 
简体中文 
日本語 
Deutsch 
Español