It is ages since I used VB6 but I think you could set a reference to the Excel
object model, then you should be able to use all the Excel objects. Some of
them may need to be prefixed with excel. If they conflict with VB objects.
Unless a reference is set you cannot use intellisense.