Macros in Visual Studio (BIDS)

This post is an extended version of a question I answered on Stack Overflow because it was interesting. When I think of Macros on the one hand I recall quite complicated VBA workbooks I've done in the past and on the other hand basic keyboard shortcuts e.g. on programmable mice…