[TC] Gaming Forums
WebControl Excel - Printable Version

+- [TC] Gaming Forums (https://forum.city-driving.co.uk)
+-- Forum: Community Area (/forumdisplay.php?fid=14)
+--- Forum: Technology Area (/forumdisplay.php?fid=82)
+---- Forum: Tech Support (/forumdisplay.php?fid=85)
+---- Thread: WebControl Excel (/showthread.php?tid=7067)



WebControl Excel - Ash - 2013-05-21 17:38

Hey guys

Wanting to put an ActiveX in my Microsoft Excel sheet.

Cant figure out (nor can google) how to get it to autoload a set URL for when the workbook opens?

Anyone got any ideas?

Thanks

Ash


RE: WebControl Excel - Elmo - 2013-05-21 20:07

No. ActiveX needs to die in a fire, it's been outdated for over 10 years.

Use vbs instead, there's plenty of stuff floating around about how to use it to grab and parse URLs.


RE: WebControl Excel - Ash - 2013-05-21 20:22

Basically I need an iFrame in excel... Is this possible via vbs? Smile


RE: WebControl Excel - Pete - 2013-05-22 15:49

Yes but you won't be able to access content of the iFrame if you wanted to scrape data from it.


RE: WebControl Excel - Elmo - 2013-05-22 19:49

You'd grab the source of the URL and parse/scrape that.
You don't want a frame unless you're planning on displaying an actual webpage. If you *do* want to display a webpage as is, you probably don't want to be using excel (although it is probably possible).