Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

List Day-Ahead Prices to Excel

0

Hello!

I'm trying to scrape day-ahead prices from this website (www.epexspot.com) into excel's collumns. 

But, I have 2 restrictions:

I want only for a specific month and only for a specific country. 

I tried to use the tutorial ("Import web data to excel using VBA macros") (https://www.youtube.com/watch?v=IOzHacoP-u4) but I can't do the proper modification. 

Thank you in advance! :) 

Answer
Discuss

Discussion

For which specific values do you want to get this price? You have to tell the macro from which part of the page to get the data.
don (rep: 1989) Jul 30, '19 at 10:04 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login