How do I download data into MS Excel from a Website that takes a l

G

Guest

There is a stock broker's Website that I can access with a login/password.
How can I download data from that account into an Excel spreadsheet? My OS is
WIN XP. I have tried both a WebQuery and a Macro that I wrote but have been
unsuccessful. The program chokes up at the login stage.
Your help will be deeply appreciated.
 
G

Guest

Maybe Copy > PasteSpecial > Text, and then Data > Text to columns to split it
into separate columns.........

Vaya con Dios,
Chuck, CABGx3
 
G

Guest

Maybe try turning on the Macro Recorder and then go through all the normal
steps you would do by hand to import the data.....then turn off the recorder
and see what you have.......perhaps something good enough to edit to make it
right.

Vaya con Dios,
Chuck, CABGx3
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Download excel doc from website, can this be done? 1
Download data from secure website into new Worksheet 12
Import data from a website to excel 1
How do you download reatime stock prices into a spreadsheet? 2
Lookups - how to obtain data from a master spreadsheet into another 5
Import data from web page into excel 6
Values from website turned into useable number values 3
download info from a web site to Excel 3

Top