I'm thinking what you are trying to do would be possible, being Office and SharePoint are both Microsoft. Have you tried doing this manually once while recording a macro to see if it records the script for you? It's helped me get started on alot of scripts.