SOLVED

[SOLVED] How to download excel file from Microsoft FORMS

%3CLINGO-SUB%20id%3D%22lingo-sub-2655250%22%20slang%3D%22en-US%22%3EHow%20to%20download%20excel%20file%20from%20Microsoft%20FORMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2655250%22%20slang%3D%22en-US%22%3E%3CP%3EGood%20Morning%3CBR%20%2F%3EWe%20have%20Office%20365%20and%20we%20are%20Microsoft%20Form%20users%20to%20accept%20job%20applications.%3CBR%20%2F%3EI%20would%20like%20to%20know%2C%20if%20there%20is%20any%20way%20that%20VBA%20can%20automatically%20download%20the%20excel%20file%20created%20by%20Forms%20and%20then%20treat%20the%20information%20contained%20in%20that%20file.%3CBR%20%2F%3EThank%20you%20for%20your%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2655250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2655340%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20download%20excel%20file%20from%20Microsoft%20FORMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2655340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1084899%22%20target%3D%22_blank%22%3E%40csoares%3C%2FA%3E%26nbsp%3BIf%20you%20open%20the%20form%20in%20question%20and%20click%20the%20Responses%20tab%20and%20then%20click%20the%20three%20dots%2C%20do%20you%20get%20%22Sync%20all%20responses%20to%20a%20new%20workbook%22%3F%20Perhaps%20that%20helps%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-08-17_11-56-21.gif%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F303688iAF24C2053A7DC98D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-08-17_11-56-21.gif%22%20alt%3D%222021-08-17_11-56-21.gif%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2678888%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20download%20excel%20file%20from%20Microsoft%20FORMS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2678888%22%20slang%3D%22en-US%22%3EHello%20and%20thanks%20for%20the%20reply%2C%20but%20on%20my%20Forms%2C%20I%20have%20this%20link%20to%20make%20SYNC.%20Is%20it%20necessary%20to%20have%20a%20special%20license%3F%3CBR%20%2F%3ERight%20now%20I%20have%20365%20Bussiness%20with%20Forms%20PLANE1.%3CBR%20%2F%3EThanks%3C%2FLINGO-BODY%3E
Contributor

Good Morning
We have Office 365 and we are Microsoft Form users to accept job applications.
I would like to know, if there is any way that VBA can automatically download the excel file created by Forms and then treat the information contained in that file.
Thank you for your help

4 Replies
best response confirmed by csoares (Contributor)
Solution

@csoares If you open the form in question and click the Responses tab and then click the three dots, do you get "Sync all responses to a new workbook"? Perhaps that helps?

2021-08-17_11-56-21.gif

Hello and thanks for the reply, but on my Forms, I have this link to make SYNC. Is it necessary to have a special license?
Right now I have 365 Bussiness with Forms PLANE1.
Thanks
To be honest, I do not know!
Good Morning
I think I got it.
If I use Microsoft Forms to make the form, I don't see the possibility of synchronizing with a file on Onedrive.
If you enter Sharepoint and create the form within a Sharepoint website, the option to synchronize with Onedrive appears.
Once created in Sharepoint, I can now modify this form in Microsoft Forms.