P
Phil
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.
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.