Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 36
Default Auto pull data from a website

Is it possible to make a macro to pull an entire workbook from a website. The
website I wish to pull the data from I need to login to and then click 3
links none of which change the URL to get the workbook that I need to pull.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 257
Default Auto pull data from a website

You want a macro not just to get the data, but to navigate
automatically to the proper place for it, right? I've written
a few VBA programs to navigate the web, and it's
surprisingly complex - not so complex that I didn't think it
worth the effort, but not trivial either. Is the workbook to
be downloaded entire, or is it in scattered data that you
have to read and assemble? If you can walk me through
the process of finding it myself, manually, I can figure out
what it might take to get a VBA to do it automatically.

--- "Chad Portman" wrote:
Is it possible to make a macro to pull an entire workbook
from a website. The website I wish to pull the data from
I need to login to and then click 3 links none of which
change the URL to get the workbook that I need to pull.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto pull 3 cells into 1 cell at different location? (Excel) Roady Excel Discussion (Misc queries) 1 May 20th 08 04:10 PM
How to auto update currency exchange rates in EXCEL from website Kylejo Excel Programming 1 August 13th 07 07:56 AM
inporting data from website where website address frequently chang HP Excel Programming 3 June 24th 07 03:50 PM
Script to Pull info from website into Excel [email protected] Excel Programming 2 February 23rd 07 12:58 PM
Making a auto website login script TMO[_5_] Excel Programming 0 February 7th 04 08:50 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"