1. No, there is not any really good documentation. :sick:
2. The usual way is:

open Excel
record a macro with the actions you want to do
analyze the recorded VBA code and look for a similar...