Yes you can do it in both Excel 2003 and 2007
Did you know that you can get an addin for Excel 2007 for two way synchronization and you can write a macro to update a list from SharePoint via VBA code?
Just google "Publishing ad Synchronizing Excel 2007 tables to SharePoint Lists" to find the addin.
As for the Excel 2003 or 2007 vba code, this was cool.
A client wanted to color code a sheet from excel so we wrote code to dynamically create the list, copy it to another worksheet and colour in cells depending on the value in one column...
Just one click and this list always comes out nicely formatted.
Another case where a little coding can make life easier!
For Excel or SharePoint questions just goto:
http://www.macroview.com.au
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment