jonathanwang003
Board Regular
- Joined
- May 9, 2014
- Messages
- 133
I used to record a macro to scrape this url:
"https://www.marketwatch.com/investing/stock/NVDA/options?countrycode=US&showAll=True"
Two issues have happened since I upgraded to 2016.
1. The Query Editor says its unable to do so because of Internet Explorer Compatibility Mode
2. 2016 pulls in query tables and creates that connection.
I prefer the old method where it just pulls in data. Is there any way to still do this with VBA while keeping it just as data (clear the query table formatting etc)?
"https://www.marketwatch.com/investing/stock/NVDA/options?countrycode=US&showAll=True"
Two issues have happened since I upgraded to 2016.
1. The Query Editor says its unable to do so because of Internet Explorer Compatibility Mode
2. 2016 pulls in query tables and creates that connection.
I prefer the old method where it just pulls in data. Is there any way to still do this with VBA while keeping it just as data (clear the query table formatting etc)?