A new page about appending text to a text file. To get rid of it, just save in the new format as a macro enabled workbook (*.xlsm).ġ8th February 2018. The macros work just fine, but the message is annoying. There is a limit to how much time, I can spend on this, so please understand that I cannot promise an answer or a new webpage but I read all mails!Įxcel 2016 introduced a new bug: When you open (some) spreadsheets with macros made with Excel 2003 or older, you get an error message, "Automation error". More advanced is process modelling and using the Excel Solver for raw mix calculations to get the right chemical composition of the cement clinker.įeel free to send me a mail, if you have questions or want to suggest new examples. I work as a process engineer at a cement plant, and most of my experience with VBA comes from using it on the job - mostly automated import and "crunching" of process data. If they don't work in other versions, please blame Microsoft and not me. There are also some spreadsheets with macros for download.Īll examples were made in either Excel 2000 or 2003. On most pages there is code that you can highlight with the mouse, copy and paste into a VBA module. The easiest way to find out if these pages offer an answer to a specific question may be to use the search function at the top. That said, there can be ample inspiration, if you are playing with Excel's macro recorder. Most of the pages target the user with some experience, but who may wonder how to solve a particular problem, or how to make the code more efficient. Other examples are the fruits of reader requests. I just share my experience with code examples that have been useful to me.
This is not a tutorial (plenty of those).
You can even build advanced applications for other users, if you know how. VBA is a powerful tool that enables you to do things automatically, that would otherwise be very time consuming and prone to errors. These are my pages about programming in Excel using VBA macros (Visual Basic for Applications).
Excel VBA macros - tips, tricks and examples
0 kommentar(er)
