How can one show columns from a SharePoint document library into an Excel sheet. Properly with VBA, but I don't now how?
1
-
Document libraries provide a default functionality of export to excel. Why not use that?– TanmayJan 6, 2015 at 8:41
Add a comment
|
2 Answers
Go to your list > in Ribbon and you will find export to excel option you can simply use it
answered Jan 6, 2015 at 8:54
The Export to Exel option, export the whole library to Excel. I want to open the SharePoint item which is an Excel document and prompt certain SharePoint columns into the header....