I'm trying to get data from a website that doesn't support Internet Explorer. Also, the data is behind a log in page. When I use get data from web, it says my credentials are invalid when I try to log in. When I use the legacy web, I continually get script errors and it cannot load the webpage. When I try to open the webpage in IE, it can't load. Is there a way to use chrome to get data for excel? I have the most up to date version of Microsoft 365. I appreciate the help!
Hi dmhunt97 and welcome to the forum,
I too have been researching this question and find VBA is how some YouTube videos show a method. You need to add a few libraries to Excel first.
See https://www.youtube.com/watch?v=5BZ6ltDfTWw or https://www.youtube.com/watch?v=inXUOu5bwAE
If this is somewhat understandable then keep asking and I'll find the next step.
I have seen possible future upgrades to Power Query that might help with this question.
https://answers.microsoft.com/en-us/...6-4ae667bfaa46
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks