(Solved) – How can we Upload an Excel file into Share point with authorization credentials embedded in VBA Code?

  • by

I wrote a VBA code to upload excel file into share point. Since, i have the credentials to access share point, simple ‘SaveAs’ function in VBA helped me in this regard. If this code runs on another user, pop up appears asking for Share point credentials. i want to eliminate this pop-up by embedding credentials in VBA code itself ? it is important to embed credentials in vba code, as we are scheduling a job and moving it to server. Thanks in advance.

Leave a Reply

Your email address will not be published. Required fields are marked *