How can one show columns from a SharePoint document library into an Excel sheet. Properly with VBA, but I don't now how?

  • Document libraries provide a default functionality of export to excel. Why not use that?
    – Tanmay
    Commented Jan 6, 2015 at 8:41

2 Answers 2


Go to your list > in Ribbon and you will find export to excel option you can simply use it


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....

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.