Hi,
I'm just wondering if someone could clarify something for me, regarding the future use of capturing web data in Excel / Access, using HTTP requests etc.
As developers who often use Excel / Access to collect data from the web, we of course often use Microsoft Internet Controls and similar references to write modules to create an IE object and collect data and deal with HTML etc.
When Microsoft announced Microsoft Edge a few years ago, they made it clear that ActiveX will no longer be supported. This meaning that to use Microsoft Internet Controls for example, we would have to rely on IE11 as that is still installed on Windows 10. This works fine as I'm sure many of you have found the same.
But does anyone know what the solution will be in the next version of Windows? as I strongly doubt IE11 will be included in the next version. Microsoft have said they only left it in Windows 10 largely for legacy purposes.
Will we still be able to capture web data at all using VBA after IE11 is gone, and therefore IE no longer exists?
I often use Microsoft WinHTTP Services, version 5.1 for some APIs. Will this still be usable? or is that reference reliant on IE as well?
Thanks in advance for anyone who can answer these questions,
Matt
I'm just wondering if someone could clarify something for me, regarding the future use of capturing web data in Excel / Access, using HTTP requests etc.
As developers who often use Excel / Access to collect data from the web, we of course often use Microsoft Internet Controls and similar references to write modules to create an IE object and collect data and deal with HTML etc.
When Microsoft announced Microsoft Edge a few years ago, they made it clear that ActiveX will no longer be supported. This meaning that to use Microsoft Internet Controls for example, we would have to rely on IE11 as that is still installed on Windows 10. This works fine as I'm sure many of you have found the same.
But does anyone know what the solution will be in the next version of Windows? as I strongly doubt IE11 will be included in the next version. Microsoft have said they only left it in Windows 10 largely for legacy purposes.
Will we still be able to capture web data at all using VBA after IE11 is gone, and therefore IE no longer exists?
I often use Microsoft WinHTTP Services, version 5.1 for some APIs. Will this still be usable? or is that reference reliant on IE as well?
Thanks in advance for anyone who can answer these questions,
Matt
