UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Scrape Information From Website And Store In Worksheets, mac 2011    
 
   
cm387
post Oct 10 2016, 02:29 PM
Post#1



Posts: 3
Joined: 10-October 16



Hi guys,

Very new to VBA and I am trying to write a program that will scrape data from multiple links and then store the data into different worksheets in excel. I keep getting error 1004 and not sure how to solve it, if anyone could help me please that would be great. Below is the line in which the error occurs. I would also like the information to be refreshed every morning at 08.00AEDT if thats possible?

With ActiveSheet.QueryTables.Add(Connection:=mystr, Destination:=Range("A6"))

Thanks,
Conor
Attached File(s)
Attached File  VBA_code.txt ( 864bytes )Number of downloads: 5
 
Go to the top of the page
 
doctor9
post Oct 10 2016, 02:54 PM
Post#2


UtterAccess Editor
Posts: 17,924
Joined: 29-March 05
From: Wisconsin


Conor,

In situations like this, it's probably in your best interest to contact the website's owners and see if they have some sort of API that you can work with, rather than try to "scrape" data from a website that could change design at any time in any number of subtle or drastic ways.

Hope this helps,

Dennis
Go to the top of the page
 
JonSmith
post Oct 10 2016, 02:59 PM
Post#3



Posts: 3,160
Joined: 19-October 10



https://www.myfxbook.com/api

They have an API and a programming section / forum
Go to the top of the page
 
cm387
post Oct 10 2016, 03:23 PM
Post#4



Posts: 3
Joined: 10-October 16



Thanks for your help, I sent than an email.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    14th December 2017 - 11:08 PM