Amar Galla
Guest
|
 Posted:
Thu Jan 13, 2005 10:21 am Post subject:
Re: Simple Excel Sharepoint List Example Code Needed |
|
|
Been a long time since I played with such things. But basically you can
create a shared workspace in excel from the tools menu, and bind it to a
sharepoint list. This will get you the list data in one of the worksheets.
Then you can easily create a dropdown in excel to take the values from the
excel sheet which is tied with the sps list, so that any updations which
happens are synchronised between the two.
There has to be a better way, but not that I know of. This will get your
work done I guess. All the best.
--
Hope this helps.
Regards,
Amar Galla
http://www.dotnetjunkies.com/weblog/amar/
"Bill Nicholas" <BillNicholas@discussions.microsoft.com> wrote in message
news:4920A5D6-1902-45AE-ABC4-0592D887E88F@microsoft.com...
| Quote: | I'm trying to get Excel to show data held in a sharepoint list as a combo
box.
For example my timesheet spreadsheet wants you to select project and
employee names from drop down boxes. My Resource booking app needs you to
select a resource and an employee etc etc. This information is available
as a
list in sharepoint.
However I cannot find any examples of how to display Sharepoint data in
Excel programatically or otherwise. Excel data in Sharepoint yes - but
that's
not what I want. Can anyone point me at a useful guide ? |
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in