External Web Data Import via VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1430228%22%20slang%3D%22en-US%22%3EExternal%20Web%20Data%20Import%20via%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1430228%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20was%20working%20on%20automating%20a%20Task%20using%20VBA%20and%20was%20running%20into%20an%20issue.%26nbsp%3B%20I%20would%20greatly%20appreciate%20it%20if%20anyone%20could%20advise!%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20topic%20is%20Financial%20Data.%20I%20am%20trying%20to%20Record%20a%20Program%20that%20will%20import%20Fundamental%20Data%20from%20a%20given%20Ticker%20Symbol%20(ex.%20MSFT%20for%20Microsoft).%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20I%20Start%20Macro%20%26gt%3B%26gt%3B%20Go%20to%20Data%20%26gt%3B%26gt%3B%20External%20Data%20%26gt%3B%26gt%3B%20From%20Web%20%26gt%3B%26gt%3B%20Load%20this%20Link%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMSFT%2Ffinancials%3Fp%3DMSFT%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ffinance.yahoo.com%2Fquote%2FMSFT%2Ffinancials%3Fp%3DMSFT%3C%2FA%3E%3C%2FP%3E%3CP%3EBut%20then%20I%20get%20a%20Script%20Error%3A%20An%20error%20has%20occured%20in%20the%20script%20on%20this%20page%2C%20do%20you%20want%20to%20continue%20running%20scripts%20on%20this%20page%3F%20Yes%2FNo%20message%20pop%20up.%3CBR%20%2F%3E%3CBR%20%2F%3ENo%20matter%20how%20many%20times%20I%20hit%20Yes%2C%20I%20still%20cant%20seem%20to%20accurately%20reference%20the%20data%20from%20these%20URL's.%26nbsp%3B%20%26nbsp%3BI%20am%20learning%20through%20this%20link%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DSgLzysnRXxA%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DSgLzysnRXxA%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20in%20advance%20if%20anyone%20can%20help%20on%20this!%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431516%22%20slang%3D%22en-US%22%3ERe%3A%20External%20Web%20Data%20Import%20via%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431516%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F685040%22%20target%3D%22_blank%22%3E%40eg1006%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FCommunity-Discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_blank%22%3ECommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%5B%23%24dp5%5D%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1431785%22%20slang%3D%22en-US%22%3ERe%3A%20External%20Web%20Data%20Import%20via%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1431785%22%20slang%3D%22en-US%22%3EAh%20I%20see%2C%20thanks%20Eric!%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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! 

2 Replies
Highlighted

@eg1006 

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. 

Highlighted
Ah I see, thanks Eric!