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

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.
--
XL Baby

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

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

Vaya con Dios,
Chuck, CABGx3



"XL Baby" wrote:

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.
--
XL Baby

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

Chuck,
Would you use that as part of a Web Query or a Macro? Tks.
--
XL Baby


"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"XL Baby" wrote:

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.
--
XL Baby

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

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



"XL Baby" wrote:

Chuck,
Would you use that as part of a Web Query or a Macro? Tks.
--
XL Baby


"CLR" wrote:

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

Vaya con Dios,
Chuck, CABGx3



"XL Baby" wrote:

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.
--
XL Baby