Welcome to the Code playground
Note that any code featured on the realce.net website is provided "As is" without any warranty of any kind, express or implied.
In no event the authors or copyright holders be liable for any claim, damages or other liability arising from, out of or in connection with the use of this content.
Please, if you are not sure of what you are doing, ask a qualified person for help.
Thank you
Excel Arrays management functions
2023, Jul 31The array represents in some way the basic material of the data project. During the different steps of the project the user will have to sort, merge, analyze different sets of data often as group of array. Using Excel in a first approach, here are some useful functions to manage Array objects in Excel.
Manage Excel workbooks with VBA
2023, Jul 20Data collection is an important step of each data project.
To perform each time the adequate analysis it's important to have access to a data toolbox, enabling the automation of some tasks related to data consolidation for example.
To help building an Excel toolbox on this matter, a few VBA code examples aimed to automate Excel workbooks management.
Example of VBA custom Excel function
2023, Jun 03Some data tools are more at ease when data is imported with flat/text file format.
It can be for example interesting to extract a list of Ids or codes from excel, store them in an flat file to be able to import/ use these codes in another tool later.
Here's a quick view on a VBA custom function designed to write a value (text, number, etc.) to text file.
Realce.net©2000-2026 -Mentions légales-Except where indicated, this work is licensed under CC BY-NC-SA 4.0
- Page rendered in 0.0081 seconds -