The Visual Basic for Applications service lets you interface with SharePoint from Microsoft Office applications. SharePoint includes a database that you can use to retrieve data or import documents from the SharePoint service. Use VBA to open the SharePoint URL and query for the data you want to display in the Office application, such as Access, Word or Excel. DoCmd.TransferDatabase acExport, “Windows SharePoint Services”, “http://sharepoint/sites/customerportal”, acTable, “Customers”, “Customers” Replace the “http://sharepoint/sites/customerportal” with your SharePoint server and site name. Writer Bio
