Mutitselect in sharepoint RRS feed

  • Question

  • hey guys, 

    i want to select multi files from a sharepoint folder. if the files were saved in the Folder, the codes work. But the Codes don't work wenn i want to select the files form a sharepoint folder 

    My Code: 

    set fselect = Application.FileDialog(msoFileDialogFilePicker)

    with fselect

            .AllowMultiSelect = True

           'Select folder from the an excel datei which is oppend and saved in a sharepoint folder

            .InitialFileName = ActiveWorkbook.Path


    End With

    Do u guys have any idea to solve this problem ??



    Friday, June 14, 2019 3:31 PM

All replies

  • Hi,

    This is the forum to discuss questions and feedback for Microsoft Excel features, I'll move your question to the MSDN forum for Excel

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.


    Emi Zhang

    Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact

    Click here to learn more. Visit the dedicated forum to share, explore and talk to experts about Microsoft Office 2019.

    Monday, June 17, 2019 2:16 AM