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

X

XL Baby

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.
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
C

CLR

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

Importing Web Data into Excel from a Password Site 0
Download data from secure website into new Worksheet 12
Import data from website everyday at certain time... 2
Download excel doc from website, can this be done? 1
download info from a web site to Excel 3
Import data from web page into excel 6
Customizing SAP Download in Excel 0
how do I get rid of symbols that download in data from web 1

Top