View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Amitabh Amitabh is offline
external usenet poster
 
Posts: 5
Default Update back to shaprepoint list from dowloaded Excel file

Hi

I am having a client requirement that user can download Excel/Access file
from SharePoint list, do some changes in Excel/Access file and upload it back
to the same SharePoint list. I am working on <bSharePoint 2007</b and
<bOffice 2007</b. A user is not able to see all the records in his view,
filters are applied on <bAssigned To</b column condition is <bAssigned To
= [Me] </bon View.

I am using <bExport to spreadsheet</b option present inside <bAction</b
Menu at top of Sharepoint list. But When I opened the downloaded Excel file,
I found that it can only be Refresh from SharePoint list but cannot be
updated back. An Export option is in there in Excel but that creates a new
SharePoint list which is not my solution.

<bOpen in Access</b option is also in there but it returns me all records
present in SharePoint list, some of the records I dont want a particular user
should be seeing or editing.

Can anyone help me by telling Is there any way to update back changes to
same SharePoint list ? I am ready to write any code to achieve this
requirement.

--
Software Engineer,
Cybage Software Pvt. Ltd.