VBA SharePoint List Field Type assignments

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I will be publishing (not linked) an "excel table" to a "sharepoint list".

I am using a listobject that I load with the excel table and use the publish
from the list object.

I need to set field types in excel so that when the data gets to sharepoint
it is correct, one example is it currently pushes as a 'single line of text'
and I need the field to be 'multiple lines of text'. It would be nice if I
could push "multiple choice" fields too.

Is there a way I can set the field type of the list object fields before I
publish it? I have searched the internet several hours two times now.
Looking for specific VBA code. Using Office 2007 and SharePoint 2007
(project at MS).
 
Did you have any luck with this in the end?

I'm having the same issues.

Mark
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link to a sharepoint list 3
Excel VBA functionality and SharePoint 4
Refreshing a SharePoint list in Excel 5
Force synchronize list with VBA 0
Upload data on sharepoint automatically. 1
Creating a new "directory" on Sharepoint 5
Check a file into SharePoint 2
MS Access - Form - Upload document to Sharepoint Server (whoes folder is mapped to my PC) from Acce 0

Back
Top