Posting from VBA?

Anyone got some working VBA which will allow a post to WP from MS Office docs? I’ve looked at PocketXML-RPC (http://www.pocketsoap.com/weblog/stories/2002/05/15/wordBlogger.html) and it looks like it should do the trick (via Blogger API), but I can’t get it to log in- I guess I’m missing something to do with the support for Blogger API it is assuming vs the way its done in WP — any thoughts?

Or failing that, does anyoen have any other VBA code which will post neatly to WP via XML-RPC?

thanks