Create a New folder in sharepoint and save file to it

[tonywatsonhelp]

Hi Everyone,

I realise to do this I might need to follow instructions as well as edit some code but I'm looking for all the help i can get.

I have a name in active sheet A1 (for example "Tony Folder")

Now we have share point, so assume this is what i've done so far,
Gone to sharepoint opened the Excel doc that opened into excel online and i clicked the use in dasktop app button,
so, now i want to create a new folder in that sharepoint location the documement came from and call it the name in cell A1,
then save the document as "Tony Test1.xlsm"

so I have been trying and have no idea how i can do this, please help with any code, guides, ideas etc.

Thanks

Tony

 

[Gokhan Aycan]

Disclaimer: Never used share point!

What do you get if in Immediate window, you write:

? ThisWorkbook.FullName

Would these help?
Get the content of a sharepoint folder with Excel VBA
Open an Excel file from SharePoint site

What you can best do at the moment is define your situation I believe.

 

[JEC]

Before you could create a new folder in sharepoint, you have to sync(link) sharepoint to your driver.
That can be done from sharepoint.

Then you will find it in your explorer and can be handled te same as regular folders