Uploading Documents to SharePoint

Ok, the coup de grace of the project I've been working on. The ability to upload files to SharePoint for the others to work on. I'm breaking this task down into several steps, even if you can't get all the steps, anything you can contribute will be helpful.

1) Move desired files to a common folder. (Peice of Cake, done)

2) Create a new project folder on the SharePoint site based on values in the workbook.

Let's say for the sake of arguement that the <project name> is stored in sheets("sheet1").range("A1").value

I'll need to add a folder to this address:
http://www.dayintranet.com/engineeri...nt%20Projects/
so that it has the following format:
http://www.dayintranet.com/engineering/Current%20Projects/<Project Name>/

3) Once the folder is created, I need to copy all the files in the desired directory from (step 1) into the newly created folder in (step 2).

4) I need to be able to detect what files are on SharePoint in the folder created from (step 2) (this is incase someone re-names or adds a new file) and then download all the files onto my local machine.

Again, any help would be appreciated. So far the information I've gathered on integrating VBA with SharePoint is "Don't bother"

How about just downloading files (of known name) off of a website?

Figure I want the equivlent of right clicking on a document and using the "Save Target As..." option.