PDA

View Full Version : VBA code to import data from a website



tcambridge
11-09-2015, 04:22 PM
Hi,

I need a VBA code that help to import data from a website into my Excel sheet. Currently, I have to go to the website, log-in then manually copy all the data and paste to my Excel then format Text to Data. I am looking for a better and more effective way to do my job. Thanks so much for all your help.

Leith Ross
11-10-2015, 12:59 AM
Hello tcambridge,

Usually people will post the URL. So, I assume this is a company intranet. If it is, I can tell you from experience your chances for getting code that will work on a intranet is slim.

There are many obstacles with intranets: Privacy concerns, Access privileges, Firewall settings, etc. It is a public site then a solution is much more in your favor.