where can I find macros to download?
SolidWorks API Video Tutorials » Macro Library
There are lot of places
This forums itself (best place)
Esox Republic SolidWorks API Tools
and many more.....
Make a wish list of what you need - there are hundreds if not thousands ready for ya
Hows about record your first macro?
Retrieving data ...