Excel VBA Upload to Multiple Wordpress Blogs via XML-RPC

I am looking for help developing a basic excel workbook that includes VBA code to upload multiple posts to multiple wordpress blogs using the XML-RPC standard wordpress connection. Attached, please find a sample of how I would like data to be entered into excel prior to upload. Basically, I need one tab that stores a list of multiple blog urls with the user name and password for each. Then, I need a second sheet where I input information for multiple posts (target blog, post title, post body html, tags, categories, time/date stamp) Hit a button... it all uploads... Thanks! Rich