How To Download Excel File From Sharepoint Vba

Sub openwb dim summarywb as workbook dim vrtselecteditem as variant with application filedialog msofiledialogopen.

How to download excel file from sharepoint vba. If i wasn t logged in it would prompt me for my credentials so it could open it. I want to open an excel file in a sharepoint list via vba. Libarry export to excel. Using vba in excel 2010 i could open a powerpoint file on sharepoint by passing the url location of the file. Thanks for posting your issue in our community.

Upon opening the txt file it did not have the original text but instead the html source code for the sharepoint site s landing page to establish a login session using credentials. Set up a data connection to excel sheet. It ended up downloading a 10kb txt file same size as the other downloads. I ve test it on my side i upload an excel file with a simple macro and the file can be opened as fine in excel application. In sharepoint browse to the view you want to monitor.

When you open this file it launches excel and creates a read only connection to the list of files in the folder. Here is my code. From the onedrive app in ios android or windows 10 phone look for the offline icon for android or ios or for windows mobile devices. Instead of attempting to download a accdb file i attempted to download a 5kb txt file. In the onedrive app select the files you want to take offline press and hold a file to select it.

On a mobile device you can make files available offline which is similar to downloading files. Regarding to your issue we totally understand your feeling and requirement you would like to open a sharepoint file on excel with vba. However in excel 2016 while i get the prompt for opening excel files on sharepoint i don t get the prompt when opening powerpoint files. You can refresh this just like when exporting a sharepoint list to an excel table.