Hi all

I am working on a workflow project with our sharepoint team where we need to embed an excel form that is opened within sharepoint, populated by the user and then saved back to the server. We then have a Web Service that is called upon a successful save.

One of the issues we have is that the WS must only be called 'after' a succssful save, the problem being that we cannot make use of the AfterSave event handler as it does not work for 2007 users. I have no experience whatsoever with either Sharepoint or Web Services and am tring to come up with a solution within VBA, for which I have found the possible following fix:-

Please Login or Register  to view this content.
What I need to do however, is somehow check that the ActiveWorkbook.Save action was successful and then either allow the after save code to run (on True) or skip it (on False).

I'm struggling a little bit with this one (still consider myself a beginner ) so wondered if anyone here would have any ideas?

Remember, the user will be saving this file directly back to the Sharepoint server, not their local machine.

Many thanks in advance

Danny_