Hello.

I am really having a hard time auto-publishing my macro-created spreadsheets to Sharepoint. By using the SaveAs method, I am able to successfully upload my workbook to Sharepoint. Problem is, I'm the only person who can see it. Until I manually update the "Title" property for the file, no one else can view my file.

Does anyone have any VBA code that not only saves the workbook to SharePoint but also publishes the workbook and sets the Title property?