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    
post Oct 10 2016, 02:29 PM

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"))

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

UtterAccess Editor
Posts: 18,213
Joined: 29-March 05
From: Wisconsin


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,

Go to the top of the page
post Oct 10 2016, 02:59 PM

Posts: 3,268
Joined: 19-October 10


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

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    22nd March 2018 - 06:47 AM