ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro to launch web page (https://www.excelbanter.com/excel-discussion-misc-queries/89071-macro-launch-web-page.html)

hutchie

Macro to launch web page
 

Is it possible to have a macro that will launch a certain web site in
internet explorer and then copy the data from that page and paste it
into excel?

Thanks


--
hutchie
------------------------------------------------------------------------
hutchie's Profile: http://www.excelforum.com/member.php...o&userid=34527
View this thread: http://www.excelforum.com/showthread...hreadid=542887


hutchie

Macro to launch web page
 

Anyone got any ideas?


--
hutchie
------------------------------------------------------------------------
hutchie's Profile: http://www.excelforum.com/member.php...o&userid=34527
View this thread: http://www.excelforum.com/showthread...hreadid=542887


Dominic LeVasseur

Macro to launch web page
 
hutchie,

If the data you are pasting is from a table on the webpage, you can use Web
Query under Data:Get External Data:New Web Query.

HTH

"hutchie" wrote:


Anyone got any ideas?


--
hutchie
------------------------------------------------------------------------
hutchie's Profile: http://www.excelforum.com/member.php...o&userid=34527
View this thread: http://www.excelforum.com/showthread...hreadid=542887




All times are GMT +1. The time now is 06:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com