• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Daily export from website and import into Excel

J

j_sun

Member
Hi All,

Does anyone know of any free or very inexpensive macro/automation software out there that will help me accomplish the following:


1. Log into my survey online.

2. Use the built in tools on the site to export the results into CSV

3. Import and append the day's results into my master excel sheet I track the survey results on.


I've trialed WinAutomation and I like it very much but my company will never pay that much for something. I need a free or cheap alternative.


Regards,

Jason
 
Hi, j_sun!


I know about one free but if you want to turn it in very inexpensive (better without the initial "in"), it's up to you.


Give a look at this link, it works for a website without login, play a little with it while I tried to find where I saw something with login:

http://chandoo.org/forums/topic/macros-web-query-huge-headache-can-anyone-help-me#post-21709


Just advise if any issue.


Regards!
 
Hi, j_sun!


Here it is:

http://www.dailydoseofexcel.com/archives/2011/03/08/get-data-from-website-that-requires-a-login/


Copied from:

http://chandoo.org/forums/topic/web-query#post-18975


Regards!
 
You must log in or register to reply here.
Back
Top