<div>
<div class="content wysiwyg-content">
I have created a VBA script to automatically download sharepoint lists into my Access 2010 database, however, i want to be able to hardcode my user credentials into the script so that it doesn't prompt when trying to connect. I'm using the DoCmd.TransferSharePointLi<wbr />st Method &nbsp;to call the lists. Is there a secret switch or someway to save the credentials in there?
</div>
</div>


I have created a VBA script to automatically download sharepoint lists into my Access 2010 database, however, i want to be able to hardcode my user credentials into the script so that it doesn't prompt when trying to connect. I'm using the DoCmd.TransferSharePointList Method  to call the lists. Is there a secret switch or someway to save the credentials in there?

Saving sharepoint credentials in Access import VBA script

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.