locked
Unable to access SharePoint 2007 SharedWorkspace object from Excel 2010 RRS feed

  • Question

  • Hi All,

    I've tried posting something on the Excel forum but had no luck - just wondered if anyone here might have any idea what's going on. (Moderator Note: The thread there has stopped with no result. I have asked in that thread that any further comments on the question be posted here)

    I've got some VBA code which manipulates a SharePoint 2007 workspace by using the ThisWorkbook.SharedWorkspace object. When I open the workbook directly from SharePoint using Excel 2007, everything works as expected.

    When I open the same workbook from the same location in Excel 2010, I receive an error from VBA, caused by the ThisWorkbook.SharedWorkspace object being 'Nothing'. Is there something that prevents the Excel 2010 object model from manipulating a SharePoint 2007 workspace? Has anyone seen this before?

    Many thanks,

    Jon


    • Edited by Mike Walsh FIN Thursday, March 31, 2011 9:47 AM Moderator Note added
    Thursday, March 31, 2011 9:30 AM

All replies

  • It would appear that Microsoft have decided to deprecate the SharedWorkspace object in Excel 2010.

    http://msdn.microsoft.com/en-us/library/ff862502.aspx

    Perhaps some kind of error message, rather than a null object, would be good? Or suggesting an alternative way of performing operations which have been available since Excel 2003 then removed without warning. Thanks MS.

    Monday, April 4, 2011 10:13 AM
  • Does this self-found answer satisify you (in the sense that it answers your question!) - if so I can mark your post as an answer and lock the thread?

    Moderator

    P.S. This is not a new development. Functionality in combination with SharePoint was removed in Excel 2007 compared to Excel 2003 too. There I saw it as being removed so that people would be encouraged to move their reports of SharePoint lists from Excel to Access (Access 2007 having new linking/syncing possibilities with SP and a good report designer).


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, April 4, 2011 12:07 PM
  • It satisfies me in the sense that it answers the question. I think the way in which the functionality has been removed and the lack of documentation is rather unsatisfactory.

    Saying that it's not a new development because Microsoft have removed features without warning in the past is both disingenuous and unhelpful. This is a severe, breaking change which has caused me serious difficulty. This should be explicitly stated in a list of breaking changes moving to Excel 2010, rather than hidden in a one-line note deep within MSDN.

    Monday, April 4, 2011 12:19 PM
  • > Saying that it's not a new development because Microsoft have removed features without warning in the past is both disingenuous and unhelpful.

    Perhaps you are wrongly taking the "Microsoft Community Contributor" to mean that I work for Microsoft. Nothing could be further from the truth

    I was merely trying to say that this was not the first time that a feature had been removed between one version and another. Nothing more.

    In fact if you search newsgroup posts from 2007 you might well find some negative comments from me about the function having been withdrawn from Excel 2007. Certainly I made some within the Office beta program at the time.

    In other words I was trying to sympathize with your position NOT to say that as they had done it before they were entitled to do it again.

    Mike

    [P.S. My own personal bugbear is the on/off/on situation with the embedded database system. In WSS 2.0 it allowed only limited size databases. In WSS 3.0 it allowed any size of databases. But in SPF 2010 we were back to a restricted size (4GB) again and no amounts of protest pre-RTM could get unlimited back. (Although using the R2 version of SQL Server 2008 Express and not the embedded version you could get that figure up to 10GB).]

     


    SP 2010 "FAQ" (mainly useful links): http://wssv4faq.mindsharp.com/default.aspx
    WSS3/MOSS FAQ (FAQ and Links) http://wssv3faq.mindsharp.com/default.aspx
    Both also have links to extensive book lists and to (free) on-line chapters
    Monday, April 4, 2011 12:27 PM
  • Fair enough, and glad to know it's not just me. Thanks for your comments and apologies if it came across slightly harsh, bad day at the office and all that...
    Monday, April 4, 2011 12:29 PM