Share via

Automatically saving file to SharePoint folder

Anonymous
2021-11-22T14:38:54+00:00

Hello,

 I use Microsoft Visual Basic for Applications in a Microsoft Excel file to automatically create and save a new Microsoft Excel file to a share drive folder like this:

ChDir "\MainFolder\public\teampublic\team\teamname\Data_Management\Personnel Equipment Input Files"

We have transitioned to Teams and obviously this no longer works. What is the Teams/SharePoint equivalent to save the file to the Sharedrive Files section of Teams/SharePoint? The current structure of our teams is as follows:

Team, Sharedrive, Data_Management, Personnel Equipment Input Files

Thanks,

Andrew

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-22T19:59:01+00:00

    Going to try a couple of versions of that but just some quick testing is not working.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2021-11-22T16:31:07+00:00

    Open the folder in a browser, copy the URL and then append \filename.xlsx as the path in SAVEAS statement in VBA

    for eg pass this as the full path to the file to save

    "https://yourcompay.sharepoint.com/sites/foldera/folderb/filename.xlsx"

    Was this answer helpful?

    0 comments