May 31 2020 07:10 PM
Hi, I was working on automating a Task using VBA and was running into an issue. I would greatly appreciate it if anyone could advise!
The topic is Financial Data. I am trying to Record a Program that will import Fundamental Data from a given Ticker Symbol (ex. MSFT for Microsoft).
So I Start Macro >> Go to Data >> External Data >> From Web >> Load this Link: https://finance.yahoo.com/quote/MSFT/financials?p=MSFT
But then I get a Script Error: An error has occured in the script on this page, do you want to continue running scripts on this page? Yes/No message pop up.
No matter how many times I hit Yes, I still cant seem to accurately reference the data from these URL's. I am learning through this link: https://www.youtube.com/watch?v=SgLzysnRXxA
Thank you in advance if anyone can help on this!
Jun 01 2020 09:53 AM
Hello! You've posted your question in the Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.