I am using late binding method to use Excel object in VB6. My problem is for code like
VB Code:
  1. Set oXLBook = oXLApp.Workbooks.Add 'Add a new workbook
is easy and well known but what about other complicated codes ? for example how do I set Header and Footer and etc.

Basically I would like to know is there a way I can find out the list of properties or methods for Excel and how to use it?