Excel VBA programmering.ppt

Erik Westermann Teknologisk Institut, Informatik, IT-udvikling AGENDA Dagens timebox Summary Macro Recorder Records exactly what you did Vital to demonstrate your precise intention! You can subsequently eliminate redundant lines With VBA knowledge you can improve the code significantly Useful way of checking correct usage of complicated methods Visual Basic Editor A means of editing your macros …and much more Many ways to run macros Choices will be determined by the purpose/style of the project Why use the Recorder? Speed of programming Opacity of the language Large number of objects Goo