I will be publishing a non-linked "excel table" to a "sharepoint list".

I am using an excel listobject that I load with the excel table and use the
publish method from the list object to push it up to SharePoint.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is that by default it pushes some cells as a
'single line of text'
as the field type however I need the field to be 'multiple lines of text'.

It would be nice if I could also push "multiple choice" fields too.

Is there a way I can set the field type of the Excel list object fields
before I publish it? I want to be able to set the SharePoint field types.

I have searched the internet several hours two times now. Looking for
specific Excel VBA code.

Using Office 2007 and SharePoint 2007 (for a project at MS). This is the
closest I have found: http://msdn.microsoft.com/en-us/library/aa140090.aspx
;

I couldn't find where to get the Collaboration Objects.