Is there a way how to build a scraper to download .csv files

%3CLINGO-SUB%20id%3D%22lingo-sub-2497451%22%20slang%3D%22en-US%22%3EIs%20there%20a%20way%20how%20to%20build%20a%20scraper%20to%20download%20.csv%20files%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2497451%22%20slang%3D%22en-US%22%3E%3CP%3EHello.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20trying%20to%20find%20a%20way%20how%20to%20create%20with%20VBA%20a%20scrapper%20to%20download%20.csv%20files%20from%20a%20site.%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20example%20Site%3A%20%3CSTRONG%3Emouser.com%3C%2FSTRONG%3E%20on%20the%20category%26nbsp%3B%3CSTRONG%3EFilm%20Capacitors%26nbsp%3B%3C%2FSTRONG%3EI%20select%20only%20one%20manufacturer%20example%3A%20%3CSTRONG%3EEpcos%3C%2FSTRONG%3E%26nbsp%3Band%20I%20want%20to%20download%20all%20.csv%20files%20in%20a%20folder%2C%20does%20anyone%20know%20a%20way%20how%20to%20do%20it%20it%20would%20help%20me%20a%20lot%2C%20below%20I'm%20gonna%20post%20some%20links%20and%20pictures%20that%20will%20help%20you%20understand%20what%20I'm%20asking.%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Feu.mouser.com%2FPassive-Components%2FCapacitors%2FFilm-Capacitors%2F_%2FN-9x371%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWebsite%2C%20without%20the%20manufacturer%2C%20selected%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Feu.mouser.com%2FEPCOS-TDK%2FPassive-Components%2FCapacitors%2FFilm-Capacitors%2F_%2FN-9x371%3FP%3D1ytdx60%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EWebsite%2C%20with%20the%20manufacturer%2C%20EPCOS%20selected%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22CSV1.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292319iAE027ECB54DF4585%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22CSV1.PNG%22%20alt%3D%22CSV1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20number%20of%20pages%20for%20example%20if%20I%20download%20all%20one%20by%20one%20manually.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22csv2.PNG%22%20style%3D%22width%3A%20714px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292320iBA893C69F650BC25%2Fimage-dimensions%2F714x117%3Fv%3Dv2%22%20width%3D%22714%22%20height%3D%22117%22%20role%3D%22button%22%20title%3D%22csv2.PNG%22%20alt%3D%22csv2.PNG%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3EHans%20Vogelaar%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3ESubodh_Tiwari_sktneer%3C%2FA%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F34444%22%20target%3D%22_blank%22%3ELeila%20Gharani%3C%2FA%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2497451%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello.

I'm trying to find a way how to create with VBA a scrapper to download .csv files from a site.

For example Site: mouser.com on the category Film Capacitors I select only one manufacturer example: Epcos and I want to download all .csv files in a folder, does anyone know a way how to do it it would help me a lot, below I'm gonna post some links and pictures that will help you understand what I'm asking.

Website, without the manufacturer, selected 
Website, with the manufacturer, EPCOS selected 

CSV1.PNG




The number of pages for example if I download all one by one manually.

csv2.PNG

Hans Vogelaar
Subodh_Tiwari_sktneer
Leila Gharani 

0 Replies