Hello.

I have code that worked perfectly when I knew the server name SharePoint is on but now I only have the http path to the SharePoint 2010 site and a document library on it.
Saving the Excel file in SharePoint using the native Save/SaveAs dialogs not a problem but figuring out folders is a different issue.

The challenge I face is to save the Excel file on a particular folder on the site:
1. First check if a folder by that name exists.
2. If it doesn't create it.
3. Add it to the save path.

I've been looking for a solution all day, appreciate if anyone knows how to achieve this, I imagine there's a straighforward model that doesn't require WebDAV or fancy XMLHTTP calls, possibly with the SharePoint object model

Thanks!