[ExcelVBA] Choice in Website

 

Hello,

Hope everyone's day is going well. I have been using Yahoo to get data into a worksheet for a couple of years at least. Something has changed in the web site so that the QueryTables.Add is not sufficient to get the data. This is because the user must make a choice that the code is insufficient to accomplish anymore.

https://finance.yahoo.com/quote/AAPL/financials?p=AAPL

the above take you to the Income Statement, but the user has to be in the site to change it to quarterly and so doing does not change the URL, it stays the same. Previously the URL would change to reflect the change from Yearly to Quarterly.

Can someone help me with the code that might be able to do this? I have never selected anything on a wb page via Excel VBA, but I think this is what is needed.

Thanks in advance. All help is appreciated.

__._,_.___

---

Posted by: who1012000@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

----------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___