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
Have you tried or looked at using the "From Web" option under the "Data" Tab in excel?
I havent used or tried yet, but ran across it when looking for ways to scrape data directly from excel, if not then you may have to look into Python as a possibility.. (not 100% sure though)
Python for sure would work, i built a few small simple scrapers few years ago. but havent tried in excel.
If you find the suggestion or solution helpful, please consider adding reputation to the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks