Extract data from web - Take a long time

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Extract data from web - Take a long time

FAQ

Thread Tools

Display Modes

#12

06-28-2014, 05:54 PM

charlesdh

Windows 7 32bit Extract data from web - Take a long time

Office 2010 32bit

Expert

Join Date: Apr 2014

Location: Mississippi

Posts: 382

See if this works.

Code:

With ActiveSheet.QueryTables.Add(Connection:= _
        "URL;http://www.zerozero.pt/edition.php?id_edicao=69891&fase=70218&jornada_in=" & Valor & "", Destination:=Range( _
        "$DO$13"))
        .Name = "edition.php?id_edicao=69891&fase=70218&jornada_in=" & Valor & ""

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to Extract key data from word	iliauk	Word	3	11-08-2013 04:37 PM
Outlook taking a very long time to open emails that feature a background picture	Mr Davo	Outlook	0	07-03-2012 12:36 AM
formula taking long time to distinct word	gsrikanth	Excel	2	03-18-2012 03:30 AM
Adding a long column of time increments in seconds	klippert	Excel	1	09-18-2010 12:26 AM
How long does MS Outlook Calendar retain past data?	dillon	Outlook	1	08-09-2009 09:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:49 PM.